Set Expression

[upaliwije]

I have a pie chart with Products as dimension. I have a list boxes for Dept for Dept 1, Dept 2. Under each of these dept there are many regions in a separate list box. In my pie chart  total of dept1 should be shown irrespective of Regions i select. Could someone pls help me to write the set experession for this.

thanks

[#2]

try inserting this to your Expression

{<Region=>} ////this set analysis will make your Expression not be affected by your region selections

Example:

sum({<Region=>} Sales) ////this means your chart will give the summation of sales without being affected by your selections under region.

[jagan]

Hi,

You can ignore the selections of a particular by using DimensionName = in set analysis experssion.  So try like this

=Sum({<Region=>} Sales)

Regards,

Jagan.