Macro to create Pivot table with details hidden(Grouped) at first.

Hi Ronanm,
I think you are looking for this line of code:

Please Login or Register  to view this content.

hope that helps

Hi Ronan,

Without your workbook, it is a little hard to follow your code. That said here is what to look for.
When you create the pivot table by hand, some options become available OR NOT. If you don't have a second level of rows then Exapand and Collapse don't make sense and won't function. If you have a Blank or non-date in a column of dates that you are trying to group on - you won't see the ability to group by dates. Pivot Tables are kind of smart (I hate accuse a program of being smart) in that it allows or disallows features based on the data or the arrangement of the data.

With all the above. Create your pivot table and see what is available. You are most likely trying to perform a pivot function, in code, that isn't available.

I hope the above helps, but can't be sure without your workbook, code and explaination of what you are trying to accomplish.

Hi

Thanks for the reply.

I have attached a screenshot of the Pivot that is created(rather than anonomising the data), and an arrow which points to the Field that hides details when clicked on, plus another arrow which point to another which has already been clicked on.

Really the wish is to have all the fields hidden when the Pivot has been created. Which I think should be OK, as it's not grouping, just hiding...

Thanks

Ronan