Set analysis question

[#1]

Hi I was wondering ..usually while using set analysis when we have something like sum{<region={'America'}>}Amount it just sums the amount where region = america,

But I have seen many places people using something like

sum{<Region=>A}amount

what does that signify?

what does field name = blank signify in set analysis and what are its uses?

Thanks for your help

[#2]

Hi,

sum{<Region=>A}amount

means ignore all selections made within region. So if you had America selected the sum would still return you the total of amount for all regions

Joe

[maxgro]

sum( {$<Region = >} amount)

or

sum( {$<Region=>} amount)

returns the amount for the current selection, but with the selection in “Region” removed;

the amount returned doesn't depends on user selection on Region field

[stevedark · Accepted solution]

As Joe says, Region= is ignore selections in that field.  It's worth knowing some of the other options though.

For example:

sum({<Region={"*"}>}Value)                                // All non null regions

sum(Region-={'America'}>}Value)                       // All regions that are not America

sum(Region-={"*"}>}Value)                                  // All regions that are null (not populated)

The Set Identifier is also important, eg.

sum({$<Region=>}Value)                                     // Use current selections, but ignore Region

sum({1<Region={'America'}>}Value)                    // Ignore all selections, but fix Region to America

sum({1<Region=P({$}Region)>}Value)                // Ignore all selections except in Region

The default set identifier is $ (use current selection), so this can be omitted as in your example.

There is lots of fun to be had with Set Analysis, and plenty of documentation on line regarding it.

Hope that helps,

Steve

[#5]

ty this was very useful

[ashfaq_haseeb]

Hi,

Check this It will help you a lot

Romancing with Set Analysis

Regards

ASHFAQ