12 Replies Latest reply: Jun 26, 2015 4:14 AM by Shiva Reddy RSS

    Some of Top 3 for each country

    Ankit Mishra

      Hi All,

      I have sample data as shown below.

      I want to create a straight table with country as dimension. I want to show sum sales for each country, but only the top 3 sales.

       

      Country     Sale

      A               5

      A               2

      A               3

      A               7

      A               1

      B               9

      B               2

      B               3

      B               12

      B               4

      C               15

      C               2

      C               1

      C               7

      C               8

       

       

      Desired Output

      A     15

      B     25

      C     30

      How to achieve this?