2 Replies Latest reply: Feb 19, 2013 2:03 PM by Paul Johansson RSS

    Pivot Table (dynamic row restriction)

    Paul Johansson

      Hi,

       

      I have a kind of advanced question. Is it possible to create a pivot table that hide row values depening on the number of dimension values? This combined with that the totals still should be summed up for all dimensions.

       

      I attach a principle example. I dont want to restrict my dimensions since then i dont get the full total. Any ideas?

       

       

      I want get from this

      Untitled.png

      to this:

       

      Goal.png

       

       

      any ideas are welcome,

      br

      Paul