Hide dimension from pivot table, but keep its grouping

[d_petrov]

Hello,

I have pivot table with 3 dimensions and one expression.

One of the dimensions is moved at the top of t he expression with the help of the blue arrow.

Is it possible to hide the values of the 2 dimensions, but keeping their grouping?

Best regards,

D. Petrov

[sunny_talwar · Accepted solution]

May be use a one time Macro to shrink the width of the column to 0

Pivot Column Width to Zero

[d_petrov]

Thank you Sunny,

It worked for me!
🙂

Best Regards,
D. Petrov

[d_petrov]

Hello Sunny,

Do you know how to hide a dimension used at the top - hide row?

Best regards,

D. Petrov

[sunny_talwar]

I have not done this before, I don't know if this is possible or not.