Compute Percentage

[User12321]

Hi,

I have a dataset with fields Supplier and Amount.

How do I compute the sum of amount by the supplier divided by the total amount for each year. 

Please advise. Thank you.

[Or · Accepted solution]

If the supplier has already been selected via filter, and you're trying to calculate that supplier's amount from the total amount for the year (for all suppliers):

Sum(Amount) / Sum({< Supplier = >} Amount)