6 Replies Latest reply on Sep 11, 2017 3:44 AM by Sreehari Katageri

    Top N using Set, within a subcategory

    Alec Chen

      Hi All,


      I want to view the top N of a measure based on each subcategory. For example, the dimension hierarchy could go like this:


      1. Channel

      2. Region

      3. Store Number


      I want to see all of the top stores of each region, or the top regions of each channel. But when I create a set on region or stores, it aggregates all and chooses from that population. How do I set a condition to only look within each category, sort of like a table calculation?


      Sample workbook is attached.



      Thanks in advance!