5 Replies Latest reply: Apr 20, 2018 7:12 AM by Sunny Talwar RSS

    Dimension Set Analysis? Maximum week for a table

    Eaphy Mao

      Hello,

       

      I am trying to create a table which will always just show sales for stores for the latest week. Is there anyway to use set analysis on my dimension to only show the sum of sales per store for the maximum of the week #?

       

      An example of the raw data is below:

       

       

      WeekStoreSales
      1Atlanta3
      1Austin5
      1Boston8
      1Chicago5
      1Philadelphia9
      2Atlanta6
      2Austin1
      2Boston7
      2Chicago1
      2Philadelphia1