### 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)
10|10000 characters needed characters exceeded

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)
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

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