cancel
Showing results for 
Search instead for 
Did you mean: 

Product Classification Ratio %

ahfadoo
Participant
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Kudos

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

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

Regards, Ammar

N1kh1l
Active Contributor
0 Kudos

ahfadoo

Do you have product classification in rows on your table ?

Br.

Nikhil