Hi all,
It feels like there should be a native solution to produce this kind of Yr on Yr comparison of cumulative data using the amazing new formula queries, but for the life of me I cannot get it to work.
My base data is a simple table of sales where each record has a data and an amount.
Using a formula query to calculate total cumulative sales to date for the same year is simple enough.
What's foxing me is how I can then use this in a graph report that looks like Debbie's example above.
What am I missing?
Thanks
David
------------------------------
System Admin
------------------------------