Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

help required for set analysis

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.
1 Reply
Anonymous
Not applicable

Do you need something like:

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

Jonathan