Percentage of a count data in Pivot table

K

Krish

I have a pivot table pulled from a database. The database has Invoice
number, line number, product number, customer number and operator code
taking the order. It is possible in a given day the order was modified by
another operator to add-on products ordered by a customer. In my pivot table
I am counting the number of lines for each customer by the operator code.
This was easy. I want to see % of lines by operator code for each customer
and not as % of row or coulmn. I am willing to add a field to my data to
achieve % of line by operator. How to write a formula?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top