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.
Thanks that worked! Thanks so much Neil Cole
I just tried to replicate in the finance cube also, looking at the ticket purchases amount (i.e. total income) in the last 7 days but testing returned 0, assume there might be a different way to do this, if you have any advise
In the Seats and Tickets Cube, you can access Total Paid Amount.When you add a widget, you can change the data source.
How about Ticket Paid Amount in the Finance Cube?
Yeah, using Finance cube (using this for budget figure) then looking at ticket paid amount in days (similar to above)
From the Help system. This will tell you the difference between the Finance Ticket Paid Amount and Ticket Purchase Amount.
That Cracked it thanks for your help!
Glad to help!