ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table question (https://www.excelbanter.com/excel-programming/349871-pivot-table-question.html)

[email protected]

Pivot table question
 
I wanted to create a pivot table like the result below.

The important thing is that I have percentages at the end of each
column and
the totals end up at the end.


Item 1 Item 2 Total Items sold

Customer A 6 Sold 60% 4 Sold 40% 10 Sold


Customer B 50 Sold 50% 50 Sold 50% 100 Sold


How can I do the above?



All times are GMT +1. The time now is 11:20 PM.

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