Hi there,
I know there are loads of threads on this subject but none seem to quite answer my question... if anyone can help I would be so grateful!
I am using CR 10.
The data structure I'm working with is
Designer,ProductNo, SubProductNo.
I have buying and sales data at SubProductNo level
Group 1 of my report is Designer Level and Group 2 is Product No level.
In the footer of group 1 I have sums of sales and buys to eliminate the subproduct detail level. I then have a field that calculates sellthru - i.e. (Total of Sales) / (Total of Buy).
Within the Designer Group (which is sorted alphabetically) I need the products sorted on the sellthru formula in descending order.
Please can somebody show me the way as the sellthru calculation is not showing as on option in the sorting expert. I'm withering away here!
Many thanks!
NixyJ
I know there are loads of threads on this subject but none seem to quite answer my question... if anyone can help I would be so grateful!
I am using CR 10.
The data structure I'm working with is
Designer,ProductNo, SubProductNo.
I have buying and sales data at SubProductNo level
Group 1 of my report is Designer Level and Group 2 is Product No level.
In the footer of group 1 I have sums of sales and buys to eliminate the subproduct detail level. I then have a field that calculates sellthru - i.e. (Total of Sales) / (Total of Buy).
Within the Designer Group (which is sorted alphabetically) I need the products sorted on the sellthru formula in descending order.
Please can somebody show me the way as the sellthru calculation is not showing as on option in the sorting expert. I'm withering away here!
Many thanks!
NixyJ