cancel
Showing results for 
Search instead for 
Did you mean: 

Percentage by dimensions on chart SAP WEBI

u7aPPE
Discoverer
0 Kudos
97

Hi, 

In cross table, we can have 1 dimension on top and 1 dimension on side, so that the function of percentage([measure name];Col) would distribute by column (example as image 1, 2024-09 has 1 in total). However, when it is using a vertical (or horizontal) table, the percentage is always shared among all mix of dimension 1 & dimension 2 (example as image 2, percentage distributed for the entire column 3). Any syntax or operator that can be made good use to give the column 3 in image 2 distributed as image 1?

 

Meanwhile, if I need it on a chart, how to make it distributed month by month (ideally to be something like image 3)?

 

image 1:

u7aPPE_0-1726695387050.png

 

image 2:

u7aPPE_1-1726695420675.png

 

 

image 3:

u7aPPE_3-1726696044665.png

 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

ayman_salem
Active Contributor
0 Kudos

use the [Dimension 1] as a break in the percentage you use.

Percentage(measure[;Break][;Row|Col]

for Examples, see help for "Percentage"

u7aPPE
Discoverer
0 Kudos
Thank you for the reply.
u7aPPE
Discoverer
0 Kudos
Thank you for the reply. Yes, you're right - the break can be used especially in table. However, would there be any context operator for the chart?