Skip to Content
0
Jan 21, 2020 at 02:23 PM

SAP Analytics Cloud (2019.21.8) - Add a line "OTHER" and calculate variations

48 Views

Hello to all,

in my SAC planning I have products grouped under brands (around 47 brands).

In my table I would like to see a small number of these brands (5), and groupe the other brands in a line called "Other".

To do so, I have to select all my brands, I have to hide lines of brands and I have to calculate the total minus each brand. (if someone have a faster way to do so...)

Then, I am doing some basic calculation between my columns. (Those calculations are not working with my line "other").

Can you help me please ? capture-decran-2020-01-21-a-152029.png