Set Analysis

[rathnam_qv]

Hi all,

i havetwo expressions

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]={'Albany'}>}[DEPOSIT SUM])  / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

in my first expression i am calculating sum(DEPOSIT SUM) for 'ABC Bank' and [ ASSESSMENT AREA]={'Albany'}. my problem is i want to calculate sum for all my ASSESSMENT AREA's...

how to do that...can any one help...

Thanks in advance!!!

Smiley

[kouroshkarimi]

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]=>}[DEPOSIT SUM])  / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

[#3]

Hi

if i understand well, you want to use set analysis for every ASSESSMENT AREA.

I would suggest you to use a pivot or straight table with assesment area as dimension

and =sum({<NAME={'ABCt Bank''}>}[DEPOSIT SUM])  / sum({<NAME={'ABC Bank'}>} TOTAL [DEPOSIT SUM])

as expression

Chris

[#4]

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]=>}[DEPOSIT SUM])  / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

[#5]

If you want all Assessment areas, simply remove that bit of the set analysis. Thus allowing 'all' Assessment areas.

=sum({<NAME={'ABCt Bank'}>}[DEPOSIT SUM])  / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

Hope this helps

James

[#6]

Why don't you try this ??

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]={'*'}[DEPOSIT SUM])  / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

[#7]

This is also work...

both are same

[rathnam_qv]

Hi Sathia,

both expressions giving me the same values

Smiley

[MayilVahanan]

Hi

Try like this

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]=>}[DEPOSIT SUM])  / sum(Total {<NAME={'ABC Bank'}>}[DEPOSIT SUM])

[#10]

sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]={"*"}>}[DEPOSIT SUM])

try like this