Forum Discussion

taeyang's avatar
taeyang
Frequent Visitor
3 years ago

How do I create a YTD which is not affected by month filter

Hi. I would like to create a table showing monthly data and YTD data at the same time.

I want to put a month slicer so that monthly data can change based on month selection in the filter but YTD being unchanged.

 

 

I created two calendar; 1.All months and  2 YTD months.

 (Max date for YTD is defined here)

 

From DB, I calculate the value in smaller scale (/1000) = "mValue"

 

And my further steps to arrive at YTD

1. Calculate YTD value using TOTALYTD with Calendar dates (Defined period)

2. Define Year in YTD value to arrive at "CYTD" and "PYTD"

3. In filter, I put months from 1. All month Calendar as below.

 

How can I fix the YTD figures so that it does not move along with the month filteration I have ?

 

 

 

2 Replies