Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculating Percentages in Blocks

Hello Guys,

I needed your help to create pertages in blocks in cross tabs.

Below is my requirement and atatched the screenshot.

I have created the cross tab and applied the breaks in the 1st column and also in the header and got the totals and grand total. But I want to create the percentages of Grand total to the individual cells.

For example:

X              1



Total       6

Y            4



Total   15

Grand total 15+6 =21

I need the percentages like this In the same format.

X              1/21



Total       6/21

Y            4/21



Total   15/21

Grand total 15+6 =21

Can you please help me out in the issue.

2nd screenshot.PNG (81196 B)
1st screen.PNG (82881 B)
Former Member
Former Member replied

Use below formula:

=Meaure Object/ Sum([Measure Object] In( [Dimension]))

1)Sum([Measure Object] In( [Dimension]))=> This will give you the 21

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question