.How to hide 9 column and only display summary total ?

[paulyeo11]

Hi All

I have add one more expression to my existing pivot table :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=151'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,

Sum(if(L5M='-1',sales)))

I only need to see the summary column. may i know how to hide those column in 1-30 , 31-60 , 61-90 ? as they are zero. So that i can reduce total 9 column.

Paul

[paulyeo11]

my QVW

[rwunderlich]

If you want to hide all columns for that Dimension, why not remove the dimension?

-Rob

[paulyeo11]

Hi Rob

Thank you for your feedback.

For AR field i need to view the aging amount.

For sales i only want to view the summary.

If i hide the diamension , you are right i can view the sales summary but unable to view the AR aging.

Paul