4 Replies Latest reply on Aug 13, 2018 9:26 PM by Nitish Pamarty

    DIFF between manual sum and grand column total function

    Saharat Sakulsaowapakkul



      I have [Store Name] as dimension and its measures which are [No. of Delivered order] and [Fulfillment %]


      My issues is simple. There are around 20 stores so I use "Grand total column" function to sum those measurement to see the overview of Logistic KPI.


      However, The number is quite weird so I export workbook into Crosstab excel file. I found that the number sum by "Grand total column" function is incorrect.


      Please kindly investigate my workbook and compare with my crosstab export in attached.



      More question: I wonder what should be the aggregation for %value ? Should it be average ?