3 Replies Latest reply: Oct 26, 2016 8:41 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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