Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)