Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
my QVW
If you want to hide all columns for that Dimension, why not remove the dimension?
-Rob
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