Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have attached screen short for my report requirement is that when i Select May/Jun 2012 month for current Financial year then in last year I have show May/jun 2011.
How we have to write set analysis.
Thanks in advance
Vikas
Please note my variables is GROSS SALES AMT and fiscalyear and month no
Do you need something like:
sum({<Year={'$(=Min(Year)-1'},Month={'$(=Min(Month)'}>} [GROSS SALES AMOUNT])
Jonathan