Apply YTD rate to all months depending on month selection

[alex59800]

Hello all

I have a DB with differents dimensions regrouped in a key as attached, trying to apply a YTD rate to all month depending on a selction, please see attached for DB and result i am looking for.

I tried by aggr but i can not figure out

Thanks a lot

[Chanty4u]

Please share your expression 

Or may be try this 

Only(

  Total 

  Sum({<DateField = {"<=$(=vMaxDate)", ">=$(=YearStart($(vMaxDate)))"}>} Measure) 

  /

  Sum({<DateField = {"<=$(=vMaxDate)", ">=$(=YearStart($(vMaxDate)))"}>} DenominatorField)

)

[alex59800]

I attached my example , do you see It ?
Best

[dwighttrumbower]

I recommend looking at this downloadable example.

https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Sense-App-Prior-Period-Comparison-with-Set-A...

[alex59800]

Hello Chanty4u

I do not have expression working, just tested wo sucess. My example of pivot result and DB is attached if you have time

Best