I have a scenario that I want to use Set Analysis in the calculation of last financial year sale for this I am writing
=sum({1<finYear={"$(vLstFinYear")}>} saleValue)
and It is working fine, but as soon as I change filter or filter from multi box then this Last financial year sale value not change it is remain same as previously
so, I want to calculate Last financial year sale value but with all current filter except financial year filter.
means when I change filter for Party or Product Category or Quarter then my SET Analysis should calculate last financial year sale value accordingly.
I am already using same syntax as you suggested and that is
=sum({1<finYear={"$(vLstFinYear")}>} saleValue)
my problem is when I am changing filter other then financial year this last year value remain same, It should change according filter.
say that I want to calculate the product category sale of last year when I am using the filter of Financial year with product category and when I will customer filter with Financial year filter then it should calculate last year customer sale.
You should not have a 1 in your expression since that means to ignore any selections made. If you put a $ instead of the 1 you will respect all selections made except for finYear.
The 1 I'm talking about is the 7th character in your expression reading from left to right.
Chart 2 isn't using the finYear field. In fact, you don't have a finYear field in your example. I guess you mean you want to ignore "Financial Year"? To ignore a field in set analysis, include it with an = after. I'm unclear what you want the chart to show, but maybe you just need to add the part in red below?
