10 Replies Latest reply: Oct 30, 2013 10:12 AM by Stanislav Strogiy RSS

    Set analisys for top values in pivot table

    Stanislav Strogiy

      How can I bring TOP 8 values for the given expression and 2 additional values specified manually in the pivot table? I think i should use set analisys in dimension or expression.

      I got 25 values of Product. To every product i have Amount. In pivot tabe i used Product as dimension and expression sum(Amount).

      How can i get something like this:

      Productsum(Amount)
      INHALIPT2356
      ANTI ANGIN2145
      HEXORAL1876
      CAMETON1500
      STOPANGIN1400
      TANTUM VERDE1238
      STREPSILS786
      FALIMINT652
      SEPTOLETE23
      STREPSILS PLUS6
      Others769

      Could someone help with this simple task?