topic Re: Current Selection sales value based on Month selection in App Development

Current Selection sales value based on Month selection

grajmca_sgp123 — Sat, 16 Nov 2024 17:51:25 GMT

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)])

Re: Current Selection sales value based on Month selection

zhaofeng — Mon, 09 Nov 2020 09:14:02 GMT

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

Re: Current Selection sales value based on Month selection

MayilVahanan — Mon, 09 Nov 2020 09:35:00 GMT

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).