% from total

[francisvandergr]

I have a table, and what i want is on each row a % from the total value of the comun. At debtor 0003 i wanna see 50%. Because i have an amount  of 3000 from total 6000. I attached an example.

[erichshiino]

Hi,
Add this expression:

sum(Orderamount)/

sum(total Orderamount)

'Total' means that the sum will ignore the dimension to give you the sum of all Orderamount.

This will then give you the % of total

Hope it helps,

Erich

[brenner_martina]

Hi, Francis,

and you can enter one or more dimensions to define, which Total or Subtotal will be taken:

sum(Orderamount)/

sum(total <Dim1,Dim2,...> Orderamount)

Best greetings from Munich

[nagaiank · Accepted solution]

For this example, checking the "Relative" box in the expression tab will give you the percentage instead of your calculating it, as seen from the attached file.