set analysis

[nareshthavidishetty]

Hi,

I need the below condition in set analysis..

(Sum({$} TOTAL SameStoreSalesTY)- Sum({$} TOTAL [Last Year MTD]))

where [Sold Location]={'17','18','29','70','76','102','105','129'}

Thanks..

[Anil_Babu_Samineni]

Perhaps This

(Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -

Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD]))

OR

(Sum({<Flag = {'$'}, [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -

Sum({<Flag = {'$'}, [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD]))

[sushil353]

Hi,

Try this:

(Sum(TOTAL {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>} SameStoreSalesTY)-

Sum(TOTAL {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>} [Last Year MTD])

)

HTH

[nagarjuna_kotha]

May be like this ?

Sum ( {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>}TOTAL SameStoreSalesTY)

-

Sum ( {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>}TOTAL [Last Year MTD] )

I hope this may helps you.

-Nagarjun

[Anonymous]

its showing some error

[Anil_Babu_Samineni]

What was the error? And In your Condition does $ is acting over there? I've removed Starting and Ending Parenthesis from my earlier set operator

Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -

Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD])

[Anonymous]

i need which requirement going to use this set analysis, please suggest.

i have been used one requirement but it not apt.