Custom Totals Row, Calculation of a market share
My apologies, but to be concise I will try to ask two questions in one topic.
If one sees the attached screen grab, every column has its own total, this is perfectly fine, however, the only possibility for the "Variance - %" column total is either a sum, average, count etc. What I am required to include in a Totals row is the variance of the "Variance - £" and the "Jun-17" column. Is this possible to achieve? Say, a custom totals function?
Is it possible to calculate the Market Share for every single row? To be more specific, I would like to calculate the total YTD of a manufacturer and divide it by the YTD of the whole industry, which currently is calculated inside of the Totals at the bottom of "YTD - 16" column. The only option I see is through writing my own SQL to calculate that. Is there a different possibility?
Any help would be greatly appreciated.