cancel
Showing results for 
Search instead for 
Did you mean: 

How to Group dimension memebers in calculation in SAC?

azm_azm
Participant
0 Kudos
611

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

View Entire Topic
horynao
Participant
0 Kudos

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
Participant
0 Kudos

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.