8 Replies Latest reply: Feb 26, 2014 2:00 AM by Oleg Troyansky RSS

    Set Analysis + Top5

    Sebastian Schuler

      Hi all!

       

      I would like to create a Pivot Chart which shows me, independently from my current selection, the Top 5 Productlines within a certain Productgroup plus all the Customers who bought one of the Top Five Products.

      It should look like this:

      Top 5 ProductlinesCustomerQuantity
      Line AA
      B
      C
      D
      123145
      32462346
      23642364
      346236
      Line BD
      R
      U
      P
      H
      123525
      234623
      346236
      2346
      34
      Line CS
      J
      E
      1231235
      46794697
      2345
      Line DE
      O
      W
      137872
      83523
      1471234
      Line EK
      Q
      W
      U
      171246
      82546
      671345
      13456

       

      My Basic Formula for Set Analysis looks like this:

      sum({$<Productgroup = {Connectors}>} Quantity) - unfortunately this formula doesn't evaluate the top five Connectors. The question therefore is, what to do in order to have only the five Productlines with the most quantity sold?

       

      I am looking forward to any suggestion!

      Sebastian