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.



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



      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