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

  • Get RSS Feed

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)