I have a table with 2 columns 1 column lists multiple entries of different supplier names can be duplicate names in the column. the second column lists an outcome 1 of 4 outcomes.
In a pivot table i want to create a formula that calculates the % of one of the 4 outcomes as of the total outcomes for a particular client.
I know how to do the formula in a worksheet would be =countif(X=1)/count(X)
the syntax is killing me please help
Cheers Matt
Hi,
Welcome on the forum.
Please attach some sample file for more details.
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Hi Rahul thanks for the welcome
I have attached an example of the data and a pivot table laid out.
I can get the dat todisplay as a percrentage of the row total but want to do it as a calculated item/feild.
Hope you can help out
Cheers Matt
Rahul I have stumped you hey?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks