Like for Like calculation

[bruno_m_santos]

Good morning,

I need your help in a calculation.

So, I need to show brands that have continuous sales in past year (if doesn't exists any period bigger than 5 days without sales)

This can be done? How?

Many thanks

Bruno

[#2 · Accepted solution]

Hi

If you don't mind doing some calculations in the script, take a look at attached document.

[bruno_m_santos]

Hi,

many thanks by your quick answer.

Do you think, that this could be made with set analysis.

Thanks in advance

Bruno

[#4]

Well, I wanted to do that at first but I have no clue how to even start.

But maybe it is possible

[bruno_m_santos]

I've tried also (without sucess), but your solution it´s very ingenious.

[bruno_m_santos]

Your tip, works fine.

Many Thanks

Bruno