ConfusedMum
New Member
- Joined
- Apr 22, 2013
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi all,
SORRY, I can't download the add-in needed to upload a mini-sheet, my laptop has admin rights set by my company and it doesn't allow any downloads.
I have an example data sheet with three columns Ticket Number (column a), Purchase Date (column b) and Group Name (column c):
In the pivot table I show the month the tickets were ordered, which group ordered them and the count of how many tickets ordered:
I know that there are 10 tickets in a book, and can see how many tickets each group buys.
How do I add another column (Column C) into the pivot table showing the actual number of books alongside the number of tickets in Column B please??
I am pretty sure it is something to do with Pivot Table Calculations, but have never done this before and am struggling to get it to work![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Any ideas please you wonderful lot of people?
Thanks you SO much,
Cathy
Also asked here Confused over pivot table calculations :-(
SORRY, I can't download the add-in needed to upload a mini-sheet, my laptop has admin rights set by my company and it doesn't allow any downloads.
I have an example data sheet with three columns Ticket Number (column a), Purchase Date (column b) and Group Name (column c):
In the pivot table I show the month the tickets were ordered, which group ordered them and the count of how many tickets ordered:
I know that there are 10 tickets in a book, and can see how many tickets each group buys.
How do I add another column (Column C) into the pivot table showing the actual number of books alongside the number of tickets in Column B please??
I am pretty sure it is something to do with Pivot Table Calculations, but have never done this before and am struggling to get it to work
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Any ideas please you wonderful lot of people?
Thanks you SO much,
Cathy
Also asked here Confused over pivot table calculations :-(
Last edited by a moderator: