Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show Details Of CY and PY in single report..
based on Year and Month.
For example..if i selected Current Year and May month...same chart need to display Previous Year and Previous year may month..
Create a variable vPrevYear = Max(Year) - 1
Use these two expressions
Sum({<Year={$(=Max(Year))}, Month={$(=Max(Month))}>} [Your Field])
Sum({<Year={$(vPrevYear)}, Month={$(=Max(Month))}>} [Your Field])