Hide one Row in Pivot Table

[cristian_av]

Hi

I need to hide just ONE row in a pivot table, but only when expanded. When contracted, it has to sum the value! Is that possible? Any hack or any idea?

Thanks!

[sunny_talwar]

Would you be able to share your qvw file to test this out?

[migueldelval]

Hi Kjh,

Is your value null? If it´s null you only need to check in "Suppress When Value Is Null" at Dimenssion Tab.

Regards

Miguel del Valle

[vinieme12]

use Dimensionality()  value

[cristian_av]

Is not Null. I can make it null (it's a value calculated in load script), but if I make it null, it dissapears, but when I contract the dimension, the sum don't consider it!

[cristian_av]

I can't.. it has data from a customer!

[sunny_talwar]

May be share mocked up data my friend or look here:

Preparing examples for Upload - Reduction and Data Scrambling

[vinieme12]

see this thread for ideas

PIVOT - One row in details that has not to be showed

[vinieme12]

just upload some dummy inline data to work with