4 Replies Latest reply: Apr 16, 2013 8:43 AM by Nils Andersen RSS

    Pivot Accumulate - 2 dimensions

    Nils Andersen

      Hi All,

       

      I've got a problem showing accumlates sales in a Pivot-chart. I've looked at all the other questions in this forum regarding similar problems, but not found a solution.

      The accumulation works fine if I have colapsed all.

      Clipboard01.jpg

       

      If I expand any of the CustomerGroups, the "Accumulated Sales" goes wrong

      Clipboard02.jpg

       

      Expression for "Accumulated Sales"

      Rangesum(sum(Sales) / sum(Total Sales),  Above([Accumulated Sales]))

       

       

      Any ideas?     I've attached a qvw showing the problem

       

      Best regards

      Nils