Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)])
Hi
I think you can try Sum({<Year = {"$(=$(vCurrentYear))"},Month={"=GetCurrentSelections(Month)"}>} [sales)])
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).