Lets say we have a vendor list with the amounts corresponding to several months/periods.
What we now want to achieve is a view which we have first column the vendor, then we have the current month amount (for which the user ran the report), then that same month previous year before and last the December amount of previous year.
But I have no idea how we can build this.
So we have the flat data but how can you make it so you have 3 comparing colunns?
Maybe somebody can put me in the right direction?
rpinxt (BOB member since 2019-01-23)