Hello,
Forgive me if this a really obvious, but thought it was worth an ask.
When looking at the Production Season Start Date (days in date) and the Production Season End Date (days in date) I can only seem to add them In two columns within a Pivot table. I would ideally like to have it in one collumn represented as Start Date - End date (01/01/2024-06/01/2024) but I can't seem to see an option to do so?
Secondly when looking at the DDiff function for looking at sales over the past 2 days & past 7 days, it seems to just give me the total when using [Total Ticket Sales] as the data, and tips on this would also be appreciated
Thanks
Alex .
You will need to put it in the Values section. You'll need to combine either MIN or MAX with DDIFF functions.
Sorry, it i wasn't clear, this was to have the date in one column as a range opposed to a sum value