Calculate % of Total expression

[#1]

Hello

How can I get the % of Total expression, which basically divides heach portion of a given total divided by the total as shown in the picture:

Thanks in advance!

[jagan]

Hi,

PFA file hope it helps you.

Regards,

Jagan.

[MayilVahanan · Accepted solution]

HI

Try like this

=Sum(Sales)/Sum(total Sales)

or

=Sum(Sales)/Sum({1} total Sales)

[Gysbert_Wassenaar]

try sum(Amount)/sum(total <Cuestionario> Amount). Another option is to check the 'Relative' option for the expression (see expressions tab of properties screen)