Forum Discussion
Solved
Reporting Net Sales - Gross less Canx
Ok, so I have c. 750k rows of sales data (and growing). It's way too much to analyse in Excel using pivots and I've found PBI is the PERFECT solution! However I still have never managed to figur...
Genius, Matt! Thanks a lot, mate. I owe you a beer.
My datasets were a bit more complicated than illustrated, but I worked out how to apply your formulae to link specific dates and report out 'net sales' easily for the very first time by various slices, including product type, sales channel, 'week #' and accounting periods.
An exercise that would have required HOURS of effort beforehand, using Excel and adding gross and cancels toegther manually...
One very happy Finance team!
Cheers.
Glad you worked it out from here. Once you get started, there is no stopping :-)