Excluding specific Dimension

[hschultz]

Hi all

I have a scenario where we need to have selections, but the chart breaks if a speciffic selection is active.

There is an example attached:

We need to be able to select on the available boxes for Customer & Month, but then, because there is no link to the employee, selecting it does not display our budget anymore.

I know you can use set analysis for excluding all selections, but we do want to be able to pick Month & Customer

So the question is if there is a way to force a colum (Budget) to bring values according to selections, but exclude certain selections, like Employee in this case?

Thank you for the assistance.

[sujeetsingh]

Hi,

Just use following expression for Budget

sum({$<Employee=>} aggr( Budget , Month,Customer,Budget))

Hope it works!

[hschultz]

Unfortunately that doesn't work

[sujeetsingh]

Why are you using aggregate

??

[sujeetsingh · Accepted solution]

Hi,

Please use this as expression

=sum({$<Employee=>}Budget)

hope it is welll

Do reply...

[hschultz]

For the month's to combine the sum accordoing to selection.

*Please note this is an example from a bigger model, and we originally tested normal sum() but it didn't calculate correctly

[hschultz]

Yes this works fairly well, and in fact i think as well as it's going to...

But the core functionality of QV kind of negates what i'm trying to achieve, because then the month's available goes according to the employee selected.

Thanks for the response though, i will test a few settings with what you have given me.

[sujeetsingh]

If all going well then just End up the thread...by the "correct answer" title.

You are welcome.

[hschultz]

Will be testing a few more settings, then i will respond appropriately. But you have been helpful so far thank you

[sujeetsingh]

No issue..