Current Selection sales value based on Month selection

[grajmca_sgp123]

hi,

In pivot table by default I would like to show current year sales value, and when ever user select the month I would like to show current year + month selected value.

I have implemented below logic but doesn't worked,can any one suggest.

Sum({<Year = {"$(=$(vCurrentYear))"},Month={'GetCurrentSelections(Month)'}>} [sales)])

[zhaofeng]

Hi

I think you can try Sum({<Year = {"$(=$(vCurrentYear))"},Month={"=GetCurrentSelections(Month)"}>} [sales)])

[MayilVahanan]

Hi @grajmca_sgp123 

If the calendar is linked with ur data model, then no need to include Month field in set analysis. 
By default, expression works with month selection also. 

Sum({<Year = {"$(=$(vCurrentYear))"}>} [sales)])
<-- above expression, it display vCurrentYear Year values by default. If the user select, any month / week / day, it will reflect based on user selection in the Year (vCurrentYear).