how to use set analysis in above case

[#1]

Dear all

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.

Please suggest.

Thanks & Regards.

anil

[#2]

John Sir,

gr8, it working fine.

In chart no. 3 I want min and max value of column 1, when I am using min(column1) then it is returning - can you please suggest

anil

[#3]

Karl & John Sir,

Thanks to both of you. Now In my opinion Set Analysis is just like magic and I can understand this magic with help provide by both of you.

Once again thanks to both of you.

If possible then please guide me or give your suggestion on chart no. 3

regards

anil

[pover]

Anil,

You can't do sum(column(1)) because you are nesting sums.  You have to write the following formula:

min( total

aggr(

(

          (

                    sum(

                              if(trnType='Sales',

                                        if(fabType='Synthetic',(BasicAmt+stdPackAmt)-PackAmt,BasicAmt)

                              )

                    )

                    -

                    sum(if(trnType='CRN' and left(sPymtModeName,2)='SP',invGrTotal))

          )

          /

          sum(if(trnType='Sales',Sqmtr))

)

,unit1,sPartyName

))