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