6 Replies Latest reply on Jan 10, 2019 7:08 PM by Ganapathy Palanimuthu

    Create set based on multiple dimensions

    Raven Kellough

      Due to security concerns, I am not able to attach the workbook.

       

      I am trying to create a set for the Top 100 customers ([highest Parent TCDP]) for FY18 ([FY]), and one for the Top 100 customers in FY19 (which will change as each month's data get loaded). Snapshot of the data:

       

      Capture.PNG

      I need to create the set so that I can do the following:

      • Use it to filter other pages in the workbook
      • combine the sets to identify clients that have fallen out or been added in the new year

       

      I have tried creating a combined field, but cannot create a set on it.  I haven't been able to figure out a calculation to do it. I've looked through the forums and can't find anything that is *quite* what I need