14 Replies Latest reply on Oct 20, 2016 10:53 AM by Mahfooj Khan

    How to calculate Latest month average?

    Kalyan Chakravarthi Gutta

      Hi all, Need help on below

       

      I have a dimension as Period with values 1609, 1608, 1607 and so on, i have 2 measures with Actual and total. I use these measures to calculate avg as Actual/Total

      My requirement is, i have a Landing page in dashboard and this page should be referring to latest months data (in this case 1609 (September 2016), i want this calculation should be dynamic since in November we will have data for 1610 (October 2016). I want this landing page should automatically update when ever new month is added to Period dimension.

       

      Please help on this as soon as possible.