This content has been marked as final. Show 2 replies
As an example, below is one record which is split by 6 country codes:-
The grand total is correct at 31.00. However, I need the sum at each row level to be the grand total (31.00) divided by the number of separate country codes (6), so the final result would read:-
Grand Total 31.00
I have tried WINDOWS_SUM and all sorts, but I cannot think of the methodology!
Many thanks in advance.