You my friend are a GENIUS! or rather a EXCEL NINJA GENIUS! As you might have already assumed the suggestion you gave worked like a charm! Thank you thank you! And thanks for the warm welcome. I'll definitely be on this site more often.
Hi everyone! I'm having a bit of a challenge trying to create a real time revenue tracker that will allow me to see how our revenue is doing (by percentage) compared to last year on the same day.
My scenario: I'm using a pivot table that can show me my revenue by year,quarter, month, and...