Product Classification Ratio %

[ahfadoo]

I have a table that Consists of a product classification row in which its members are "Black" and "White". I want to create a calculation that shows a ratio which indicates which values have been assigned to "Black" and which have been assigned to "White". Such as : Black 30%, White 70%.

Could I get some help on how to do that in SAP analytical cloud?

[N1kh1l]

ahfadoo

ahfadooI think the below would suffice for you. You can only do this calculation at Account or measure level in model and not stories.

You can replace [Sales] with your measure name and [d/BW] with your classification dimension.

%SUBTOTAL([Sales], [d/BW])

Br.

Nikhil

[ahfadoo]

This is the result I am getting with the formula used. Is there something I am perhaps missing?

Regards, Ammar

[N1kh1l]

ahfadoo

Do you have product classification in rows on your table ?

Br.

Nikhil