Forum Discussion
Incorrect Quick Measure Variance Total
Hi Paul,
Currently, this is what the table show based on AMANJAYA SPECIALIST CENTRE s/b Kedah:
(a) (b) (c) (d) (e) (f)
Sales 2018 Variance Sales 2017 Variance Total Sales Variance
4539 0 27693 -23154 32232 -27693
From my understanding (d)=(c) - (a) where we will get the variance,
(e)=(a) + (b) which is the total sales of 2018 and 2017,
so for the total variance (f), it should be (b) + (d), but not (a)-(e) as what you stated.
Is my understanding incorrect when it comes to the automatic formulation of Total and subtotal for a matrix table?
It would seem so.
I'm curious as to what the "rogue" measure is? can you post it (with the column ids) so we can see what it is actually calculating?