Sorting based on formula in group footer
Hi there,
Please, pelase help me if you can - I've exhausted every resource to try and solve what should be such a simple problem!
I have a table that has Date, SKU, UnitsBought, UnitsSold.
I have a report that groups the data on SKU and sums the UnitsBought and UnitsSold fields in the group footer.
I then have formula called {@Sellthru} that divides the total UnitsSold by the total UnitsBought.
I need the report to sort the SKU goups based on that calculated sellthu but that formula field is not available in the group sort expert.
I have been told that I can do this with SQL expressions but I have no idea how to do this - please can anyone suggest a solution - I have been trying to make this work for 3days now and I really don't seem to be making any progress - I urgently need your help!
Many many thanks in advance...
Nikki x
|