% Calculation for straight table column total

[srinivasa1]

Hi

Please guide how i can do % Calculation for straight table column total.Please find attached sample on same.

Thanks in advance for any help on same

.

[Gysbert_Wassenaar]

Use explicit aggregation functions like sum:

sum([Mfg Price])

2*sum([Mfg Price]) + 3*sum(NetSalesPrice)

And set the Total mode of the expressions to Expression Default instead of Sum of Rows.

[Anonymous]

See if the attached helps.

As mentioned above, straight table properties, number

- check Show in % & Choose your number format

[Anonymous]

Or do you need the % of the total amoun?

i.e