Max MonthDiff Value for each Month in set analysis

[diego1991]

Hi people, good day to all of you,

I have an application in which I have created a Master Calendar because I needed to calculate variations and accumulated values,

Anyway I'm having trouble with one of the rows in a pivot table in which I want to express the variation between the Current Date column in the table and the Min Date of the selected ones.

What I need for doing this properly is using min period value in every column no matter what, something like this (Min Periods Value):

Month	Jan	Feb	Mar	Apr	May
Period Value	12	11	13	10	22
Min Periods Value	12	12	12	12	12

Also my master calendar is something like this:

Month	MonthDiff
Jan	0
Feb	0
Feb	1
Mar	0
Mar	1
Mar	2

So if I use MonthDiff = 0 in a Set expression it will use the current month values, if I use MonthDiff =1 it will bring the previous period values etc.

So, what i think will work is setting the max MonthDiff in the set analysis for every Month, I'm trying to do this with the next expression:

=Sum({<MonthDiff={'$(=Max(MonthDiff))'}>} [TOTAL])

But it only displays the value for the ultimate column, I assume it is using the Max value for all of the periods (2 in this case),

Can you help me to fix this expression so it brings max value for each Month.

Thanks a lot, Sorry if my English isn't the best.