6 Replies Latest reply on Nov 15, 2018 6:56 PM by Shinichiro Murakami

    How to Utilize Grand Total of one column from one worksheet in another worksheet

    Pramod Duvuri

      I'm trying to calculate a Dynamic Rolling 12 Month SUM for 4 of my measures. I don't want to display those measures actually, but I just want to display the Sum of prior 12 Months from the selected Month in a filter.

      I didn't find a way to achieve this anywhere. So, I'm trying this approach: Display last 12 months data from month selected from Show Filter  It's working fine to display. But my ultimate target is to display the Grand Total of the displayed dates in a different sheet.

       

      Any ideas on how to achieve that?