2 Replies Latest reply on Sep 26, 2017 4:48 PM by Jessica Sanderford

# % of a previous column

So I am sure this is a total rookie problem, but I've done some research, reviewed my manuals, and am still struggling to figure out how to do a % of the previous column.  Below is an example of what I'm trying to accomplish, in a very simplified example.  The fields in gray show the data I want shown in my worksheet; however, I currently have the fields in white.

 Population Total Present Total in Suits Value Total in Suits with black shoes Value Teachers 500 50% 250 10% 25 Students 300 40% 120 15% 18 Administrators 100 20% 20 5% 1

Basically, I want column 2 to show the % of total suits out of the total present.  And I want column 3 to show the % of total black shoes out of the % of total suits out of the total present (because you can't wear black shoes unless you're wearing a suit and a part of the total - so column 3 is dependent on column 2).  I hope that makes sense.

Again, I'm sure this is a total rookie oversight, but I'm stuck!  Any help you can provide is GREATLY appreciated!

Thank you!

Jessica

• ###### 1. Re: % of a previous column

friend,

you must create a calculated field

sum ((value) * 100) / sum (total present)

regards best

• ###### 2. Re: % of a previous column

THANK YOU!  I tried that over and over again, but must have been doing something wrong, because it now works!  I appreciate your quick input!  Again, THANK YOU!