Howdy!
I'm trying to collect some data in regards to number of seats booked on particular days, from a table that has many bookings. However, when I try to create a pivot table, the date gets broken down and I'm unable to collect the data that I need.
This is an example of the table area in charting;
\1
Here is how the pivot table displays it the results;
\1
Is there any way for the pivot table to show the sum per date exactly as it is shown in the raw data?
There is also a "Year" and a "Quarter" option for the PivotTable, but it just adds to what I don't need.
Thanks for any help!
Bookmarks