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

      Hello

       

      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 ?