1 Reply Latest reply: Apr 16, 2014 10:37 PM by Wenkun Ma RSS

    Subtotals in pivot table

      I am using this expression

      sum({< GL_Ac = {'Grs'},Fl_CY={1},[Cy Code_]={'US'} >} Amount*-1*$(v_R_Sel1))/1000 in a pivot table and i have checked the show partial sums for both the dimensions. Now the totals doesn't show the right value but when i do use the aggr then it does. I am confused on why am i having the difference here? i was hoping that the pivot table does show subtotals by default and wouldn't be needing to use the aggr unless required. Any thoughts on this one?

       

      The attached spread sheet is an export of the object that i am using the expression, which shows 1082 as total but when i really add up by row it is 1090.