Confused over pivot table calculations :-(

Hi all,

I have TRIED to upload my Excel file: ticket example.xlsx

data.jpg

Pivot.jpg

I have an example data sheet with three columns Ticket Number (column a), Purchase Date (column b) and Group Name (column c) - I think I have uploaded this as an image file called Data:
Attachment 862331

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 think I have uploaded this as an image file called Pivot:
Attachment 862332

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

Please note that I have also posted this query at the MrExcel website for extra extra help.

Thanks LOADS,
Cathy

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I am providing the link because you don't have enough posts yet to make your link live:

https://www.mrexcel.com/board/thread...tions.1255338/