ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Percentage of a count data in Pivot table (https://www.excelbanter.com/excel-worksheet-functions/233470-percentage-count-data-pivot-table.html)

Krish

Percentage of a count data in Pivot table
 
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?




All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com