0 Replies Latest reply on May 10, 2018 5:36 AM by Red TypeR ha

    Compare this month and same month Last Year

    Red TypeR ha

      Hi Guys

       

      Hope you can help me in this

       

      I have a dataset with 2016- 2018 sales data. Somehow i want to select single value year or month and the table in the middle calculate the prior year ( same month last year) value.

      but no luck i can only get 0

       

      also there is some restriction where

       

      1. No time (Year / Month ) in upper Row

      2. The grand total option ( Total Option sum) has to be selected later on

       

      Hope you can help. Thx