Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list vendors, and they want to show the % represented of that vendor to Total Count. So the calculation is (Vendor Sum)/(Total Vendors Sum).
How can I show this for each row (for the vendor)?
If you have only one dimension just use this expression:
=Sum(Vendor)/Sum(total Vendor)
Then go to the Number tab and select Show in Percent checkbox.
Here is a sample.