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!