5 Replies Latest reply on Dec 18, 2017 7:17 PM by Zhouyi Zhang

    Last month of the Quarter.

    youthesh sagar

      Hi,

       

      I have dashboard which has two charts as shown in the attached screenshot.

       

      My requiremtn is that sheet 2 should sum values for all three months but sheet 1  should show last month of the quarter values.

       

       

      Eg: Q1 should show Mar data

      Q2 should show Jun data

      Q3 Should show Sep data

      Q4 should show Dec data.(Data is only available till Oct in my data set. Hence Q4 should show Oct data. This calculation should work going forward based on data availability.)

      If Nov data is loaded then Q4 should show Nov data.

       

      Please help me altering my calculation to get the desired result.

      Thank You