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
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
Hi Tom,
Right side not working that formula showing incorrect data.
Regards,
Sasi
Add comment