Show rows with no data in last 3 months

[#1]

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

[sunny_talwar]

Would you be able to share a sample?

[#3]

added to the question

[Anonymous]

Use

LOAD

Market,

Max(Date),

Sum(Revenue)

WHERE

Date>= AddMOnths(Today(),-3)

Group By Market;

If only Markets with Zero Revenue, further filter accordingly.

[#5]

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

[antoniotiman · Accepted solution]

Hi Alex,

see attachment.

Regards,

Antonio

[#7]

thanks