help required for set analysis

vikasmahajan · ‎2013-02-14

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2013-02-15

Do you need something like:

sum({<Year={'$(=Min(Year)-1'},Month={'$(=Min(Month)'}>} [GROSS SALES AMOUNT])

Jonathan

Related Topics