Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a Total and then all records can use that Total in calculations

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)?

2 Replies
whiteline
Master II
Master II

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.

Not applicable
Author

Here is a sample.