Set Analysis: Weird Dimension Bug

[SonPhan]

Hello Guys,

i have a problem regarding set analysis.

I prepare a simple demo app.

I came across an error, which I do not understand, I think in my eyes I have built everything logically correct.

The third chart should be a pie chart, if the dimension Vendor is selected as a filter, it should take the upper right chart, otherwise the upper left chart.

Hope you guys can help me with my problem!

Thanks a lot .

Son

[GaryGiles · Accepted solution]

@SonPhan 

To get the functionality that you have described in your 3rd chart, use the following expressions:

Dimension:

=aggr({1} if(Only({1<Vendor=P(Vendor)>}Vendor)=Vendor,Vendor,'Other'),Vendor)

 Measure:

sum({$<Vendor=>} Sales)

If you select one Vendor, it will present that vendor and group the rest into 'Others'.

Note: If you select 2 Vendors, it will present those 2 vendors and group the rest into 'Others'.  I think that gives you more functionality.

[SonPhan]

@GaryGiles

Thank you ! This is much better as expected!