Hi all, we analyse our gross margin by supply markets, which all of our sales and purchases are tagged to.
We have have various gos at this the past years from using the GL formula (with balance and various filters) set within a pre created matrix (works but its slow) and then to building a table which collects the info that we want and then we can pivot (works for a few months worth of data, then the dataset gets too big and the report crashes)
I presume i am not doing this in the most efficient manner, so can anyone suggest what other combo of formulae types or reports i could run to get what i need?