Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a fairly simple table with 3 columns; Market, Date and revenue.
Many of the Markets have zero revenue for certain dates.
I need to produce a table which shows a list of markets which have accumulate zero revenue in the past 3 months and one of the columns needs to display the last date there was revenue.
How can i do this?
Message was edited by: Alex Hamilton McLeod Sample data addedd
Would you be able to share a sample?
added to the question
Use
LOAD
Market,
Max(Date),
Sum(Revenue)
WHERE
Date>= AddMOnths(Today(),-3)
Group By Market;
If only Markets with Zero Revenue, further filter accordingly.
The data is already used extensively elsewhere in the same document.
Is there a way I can do this 'in chart' rather than changing the load? As i still need all the other data for other parts of the doc
Hi Alex,
see attachment.
Regards,
Antonio
thanks