8 Replies Latest reply on Nov 26, 2018 5:31 AM by Sander Binda

    Weighted average in grand total.

    Sander Binda

      Hello,

       

      In the workbook im trying to compare the average price a customer paid for a 'article 1' in a certain week to the weighted average weekprice.

      This works perfectly fine when the overview shows just 1 week, as soon as I add another week to the view the grandtotal  of the weighted average weekprice is just the average of 2,78+2,21.

      I want the grandtotal of the weighted average weekprice to show 2,37 as well because 2,37 is the weighted average weekprice of both weeks combined (27599/11660=2.37)

      Which in turn makes the grandtotal of the last column 100% (The endgoal)

      If you filter to 1 week you see that this happends.