How to Group dimension memebers in calculation in SAC?

[azm_azm]

Hi,

Here is the scenario.

There is total ten brands in my brand dimension.

For Example, Brand A, Brand B, Brand C .... Brand J.

Now, I want to create a report where I just want to see only top three brands and group other brands as "Other". The calculation of "Other" Brand should be [ Total Sales of All Brands - Sum of Top Three brands] .

Please refer below screenshot.

Anyone who has faced similar kind of issue or knows the workaround in this case. Their comments would be deeply appreciated.

Thanks

[horynao]

Hello,

I didnt find some way to set up it in SAC directly. One workaround would be R lang visualization, but it is little bit difficult. See the link below. Another way could be to pre-calculate choosen dimension before it is loaded to SAC, create dimension with top n values and "other" value, create its own model and link it to main one. But this could have a lot of obstacles.

https://stackoverflow.com/questions/70304967/how-to-select-top-n-values-and-group-the-rest-of-the-re...

Best regards,

Ondrej

[azm_azm]

Thank you horyna.

Is it really possible to use R visualization and get the result populated in table in SAC?

Adding another model and then linking will add complexity in the design and security maintenance.

Let's just hope SAC comes up with this functionality in future updates.