Skip to Content

# how to calculate percentage in crosstab?

Hi ,

I have a data in cross tab below like. here i want to calculate a percentage like AED 8178918/AED 16729388.

can you suggest what formula have to apply.

capture.png (9.4 kB)
##### Add comment
10|10000 characters needed characters exceeded

### 3 Answers

• Best Answer
Mar 15 at 08:26 AM

Hi Sasi,

Simply insert a new row below your Sum and then apply the following formula:

=Percentage([measure];Row)

which is the same as =Sum([measure])/(Sum([measure]) In Block)) Then change the cell formatting to Percentage.

Kind regards,

Tom

12630681.png (21.7 kB)
##### Add comment
10|10000 characters needed characters exceeded
• Mar 15 at 09:08 AM

Hi Tom,

Thanks a lot its working.

but i want to add that percentage values in right side column.can i add on right side.

Regards,

Sasi

##### Add comment
10|10000 characters needed characters exceeded
• Hi Sasi,

Yes, you simply insert another column to the right of your totals and then apply the formula =Percentage([measure];Col) Afterwards, change the format to Percentage.

Kind regards,

Tom

• Mar 15 at 09:37 AM

Hi Tom,

Right side not working that formula showing incorrect data.

Regards,

Sasi

##### Add comment
10|10000 characters needed characters exceeded
• Hi Sasi,

Works for me: Can you try with =Sum([measure])/(Sum([measure]) In Block)) instead? If still wrong results, please provide some more detail, e.g. another screenshot.

Kind regards,

Tom

12630681b.png (19.6 kB)