Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to fields for selecting months: Month (1,2,...), MonthName (Jan,Feb,..). Now I wan to select Previous Month in the chart
sum({$<Month={$(=Only(Month)-1)}>}Amount)
But my selections are in MonthName field not in Month. How can I refer to Previous Month if I have to select month in MonthName not in Month field? I mean when I select February, I want to show January too?
Add another Set Modifier to ignore user selection in MonthName, and everything will work:
sum({$<Month={$(=Only(Month)-1)} , MonthName= >}Amount)
Add another Set Modifier to ignore user selection in MonthName, and everything will work:
sum({$<Month={$(=Only(Month)-1)} , MonthName= >}Amount)
Hi Pedro,
This is my offer (see .zip)
Good Luck
/Luis.