Chart not affected from some of dimensions

[#1]

Hello,

I have model with 3 dimensions (Area, division, subdivision).

Within this model I have bar chart I want to affect this chart only from the area dimension (and will be affected from division and subdivision)

Thank you in advance for your answers

Elad

[#2]

Hi Elad,

please provide a short example of data.

Thank you!

Rainer

[#3]

I have 3 dimensions - Area, subdivision and subdivision.

These dimensions see employee per area, division and subdivision

I have sales date.

What I need is:

If some user chooses some area I want that in my chart I can see sales per employee in the area.

If the user chooses some division or subdivision in the area I want that my chart don't changed and I want to see sales pare employee in all the area.

Elad

[#4]

Hi,

thats for Set Analysis.

Try something like:

sum({$<division=,subdivision=>} Sales)

Have Fun With QV

Alex:)