set analysis related query

[#1]

Dear Team,

i am using a variable to get over all Daily Trade Value average in Cr. below is my equation/syntax of Set Analysis

=(sum({1}TRADE_VALUE)/ sum({1} TRADING_DAYS)/10000000)

Above mention query is working fine. its excluding all the selection and giving me result.

Now my requirement is i want same set of information ( Exclude all selection) but Daily Trade Value Average will be for Max Month.

=(sum({1} {<MONTHYEAR={'$(vMaxMonthYear)'}>} TRADE_VALUE)/sum({1} {<MONTHYEAR={'$(vMaxMonthYear)'}>} TRADING_DAYS) )/10000000

Above is the query which i have written but it is not working fine when i select any other dimension other that MONTHYEAR. Kindly help

Thanks & Regards,

JKV

[Anonymous]

Hi,

you can try with

sum({1} {<MONTHYEAR=p({< MONTHYEAR={'$(vMaxMonthYear)'}>}  MONTHYEAR)  >} TRADE_VALUE)

and the same for the second sum

BR,

Elena

[#3]

No This is not working when i am selecting Member_name dimension this showing result of max month of that particular member_name only

[Anonymous]

Maybe, in the definition of your variable, you have to insert {1} to exclude all selections.

[AbhijitBansode · Accepted solution]

Can you try below:

=(sum({1<MONTHYEAR={'$(vMaxMonthYear)'}>}TRADE_VALUE)/ sum({1<MONTHYEAR={'$(vMaxMonthYear)'}>} TRADING_DAYS)/10000000)

[#6]

Thanks .. Abhijit

[#7]

Thanks Elena for your Help

[AbhijitBansode]

anytime