I have a Query where each column has a Promoted Figure, a Non-Promoted Figure, Total Sales and a percentage of Promoted Quantity out of Total Sales.
I have a column for each Calendar Week.
Promoted 60 80
Non-Promoted 140 120
Total Sales 200 200
% Promoted 30% 40%
My Last Column is a Total. What I want to see is
Total Sales 400
% Promoted 35%
However I can't get the %Promoted in the Totals column to be the Percentage calculated using the Individual rows totals (i.e. 140/400*100 = 35%). Instead it is showing as 70% which is obviously the total of the other columns percentages.
Can any bright spark tell me how to do this, please?