1 Reply Latest reply: Nov 28, 2015 6:34 AM by Gysbert Wassenaar RSS

    How to Restrict Expression by Another Expression

    Riley MacDonald

      Hi,

       

      I have a straight table which looks like this:

       

      MarketMonthKPI Score (Calculated Dimension)Sales (Sum)
      CanadaOct-1598%200
      CanadaOct-1578%300
      CanadaOct-1576%100
      CanadaOct-1574%400
      CanadaOct-1590%300
      CanadaOct-1580%150
      ChinaOct-1580%300
      ChinaOct-1580%220
      ChinaOct-1579%275
      ChinaOct-1564%400
      ChinaOct-1567%500
      ChinaOct-1555%100

       

      I would like to restrict the KPI Score in this straight table which will also have many other records and Market&Month combinations to only take into consideration the top 3 by sales for each Market&Month combination

       

      For example:

      I would expect to see only the following records showing up in the straight table/KPI Score only:

       

      MarketMonthKPI Score (Calculated Dimension)Sales (Sum)
      CanadaOct-1578%300
      CanadaOct-1590%300
      CanadaOct-1598%200
      ChinaOct-1567%500
      ChinaOct-1564%400
      ChinaOct-1580%300