13 Replies Latest reply on May 10, 2018 8:05 AM by Zhouyi Zhang

    Table Selected Month and Same month last Year

    Red TypeR ha

      Hi Guys,


      I hope someone can help. i have a data set that has 2016 - 2018 , somehow i want it shows the Last year(Prior)  sales of what i have selected.


      For example, when i select Dec and 2018, it should sum the Dec 2017 data.


      Also, there is some restrictions


      1. The Row can not have Year or time data ( so can't do table calculation)

      2. Later on the grand total (Total option) has to be sum  (in case this is aggregation function this option is grey out)


      ( i think this has to be solved in LOD  ? )


      Hope you can help. thx