vba pivot table group test

DonkeyOte

MrExcel MVP

Joined

Sep 6, 2002

Messages

9,124

• Dec 29, 2010

• #2

I'm not sure if there's an easy answer here... the likes of TotalLevels will help to some extent but not where this is only 1 level of Grouping (ie Dates by Month) given an ungrouped field would also return 1.

Hopefully this bump will trigger others who may be aware of a solution.

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,247

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Dec 29, 2010

• #3

It's easier just to handle (or ignore) the error.

 

Upvote 0

DonkeyOte

MrExcel MVP

Joined

Sep 6, 2002

Messages

9,124

• Dec 29, 2010

• #4

Rory, I remain curious though as to whether or not there exists a fool proof way of establishing the Grouped status of any given field ?

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,247

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Dec 29, 2010

• #5

Not that I am aware of, no. (As it happens this came up fairly recently in a certain newsgroup full of heavy hitters, and no-one there knew of a good method).

 

Upvote 0

DonkeyOte

MrExcel MVP

Joined

Sep 6, 2002

Messages

9,124

• Dec 29, 2010

• #6

OK thanks (now feeling slightly less dense)

 

Upvote 0

C

cdjones

New Member

Joined

Sep 30, 2009

Messages

8

• Dec 29, 2010

• #7

Re: vba pivot table group test [SOLVED]

all, thanks

on error resume next
pf.ungroup
on error goto 0

?

 

Upvote 0