Hi,
I have more than 10 + years of experience in Reporting and data analysis using MS Excel, MS Access, VBA (Visual Basic for apps), data manipulation, data validation, data management, building Tracker, Dashboard.
I require one clarification -
Flat lines(4/8/12 months) to be calculated from Order month .. is Order month inclusive of that 4/8/12 months ?
For ex -
Order month is Mar-2018 and revenue is < 250k pounds, and Revenue is delayed by 1 month, hence flat lines for Apr'18 -July'18 .. is this correct understanding ?
From where do i need to calculate whether revenue is getting delayed or not (1 month) is it based on Order month ?
Thanks in advance,
Saurabh