Getting all possible for a dimension (Set Analysis)

[zagzebski]

I need set analysis where if "Hammer" is selected from the below data it will add all Salary and Revenue for that specific Region (which is "East") because Hammer belongs to that Region.

   

Thanks,

Z

[vishsaggi]

Try this?

LOAD * Inline [

Region, Department, Salary, Revenue

EAST, Nails, 4000, 50000

EAST, Hammer, 5000,

WEST, Screws, 6000, 60000

WEST, Saw, 7000, 70000

];

Using straight table:

Add no dimensions

Add Expressions like:

Salary

= IF(GetSelectedCount(Department) > 0, Aggr(Sum(Salary), Department), Sum(Total Salary))

= IF(GetSelectedCount(Department) > 0 AND Sum(Total Revenue)= 0 , Aggr(Sum({<Department=>} Revenue), Region), Aggr(Sum(TOTAL Revenue), Department))

[antoniotiman · Accepted solution]

Hi Steve,

try

Sum({<Region=P(),Department>} Revenue)

Regards,

Antonio

[zagzebski]

Thanks. Worked!

Z