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

                2

                3

Total       6

Y            4

              5

             6

Total   15

Grand total 15+6 =21

I need the percentages like this In the same format.

X              1/21

                2/21

                3/21

Total       6/21

Y            4/21

              5/21

             6/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