4 Replies Latest reply on Sep 7, 2018 4:26 AM by megha gawali

    Top N Sales for Overall and Specific Region

    M N

      Hi All,

       

      I have a dashboard with "Region" filter and a table. So, my goal is, when I choose "All', the table should ONLY show the top N Profit for whole region, and when I choose a specific region, the top N Profit for that selected region will be dipslayed. I've already achieved my second goal, but don't know how to display the top N for whole region (when I select "All" the table shows ALL region along with top N for each). Anybody know how to solve this problem? I've attached a sample twb file using Sample Superstore data for your reference (cannot attach twbx file since it's said file too large, sorry!) . Thanks very much.