Pivot table- How to hide colums?

[#1]

Hello All,

I am building two pivot tables having the same content. One for MTD and the other for YTD.

The two tables have same dimensions. I want to place the two tables next to each other. But, i want to display the dimension only once.

How can i hide the column in the second table?

Thanks,

Deepti

[sunny_talwar]

Why don't you use two expressions instead of using two different Pivot Tables? Is there a reason you are doing that?

Best,

Sunny

[pratap6699]

conditionally disable that expression....or dont use another same expression

[#4]

Hi sunny,

Please find the  sample screeshot attached.

This is the kind of display I need.

For YTD table, I have placed underneath the MTD table so as to hide the repetitive columns(KPINames,Target,).

But, when i apply filters, these hidden columns pop up. how can i avoid that?

Thanks,

Deepti

[sunny_talwar]

For the MTD Table try un checking 'Size to Data' on the Layout tab of chart properties and see if that helps:

This will show you white space instead of reducing the size of the table when you make a selection for filtration.

Best,

Sunny