PivotField.AutoShow and Excel 2011 for Mac problem

[gerardbaste]

Hi everybody,

I am trying to use the [.autoshow][1] method in a pivot table but I get a "1004" error message every time. I am trying to us it under Excel 2011 for mac. I am not sure if this method works on my version of Excel, could somebody help?

Here is the procedure I have been working on

Please Login or Register  to view this content.

The source table looks like this (I shortened it, it actually has 91 rows)

Please Login or Register  to view this content.

And the pivot table looks like this

Please Login or Register  to view this content.

Thank you!

[CK76]

I'm guessing that "Digital channel" is in data field and not Row Label.

Check what calculation is used for the field. You need to reference it like... "Sum of Digital channel", depending on calculation type.