5 Replies Latest reply: May 31, 2016 4:49 AM by PAUL YEO RSS

    How to make Pivot table with Pick(Match compute faster for amount with -ve and +ve value ?

    PAUL YEO

      Hi All

       

       

      Table 1 Expression :-

       

       

      Money(Pick(

      Match([Pls select 601st Dim],'sales','eXP','rEVENUE','nET_PROFIT'),

      Sum (($(ColumnDim601)/$(Columndim89))/1000),

      Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount/1000)/$(Columndim89),

      Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount/1000)/$(Columndim89),

      Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount/1000)/$(Columndim89)),

      $(vMoneyFormatK))

       

       

      When I create the above pivot report. i notice that when my expression compute with positve value for example sales it have no issue. But when i compute eXP which have negative value it very slow , it there any way i can speed up ? As my issue is if i load the actual data , it will get out of memory error.

       

       

      Table 2 Expression :-

       

      Sum({<eXP={eXP}>}Amount/1000)/$(Columndim89)

       

      For table 2 i have no issue .

       

      Paul