total not matching for one particular column in straight table...??
we have a stright table where we are showing different offerings and their repetive revenue. but for one month which is high lighted in the below image the total counts are not matching. i mean total value is not coming as correct for it, where as for other columns its coming correctly...
after adding above it should give 68989 but it is showing 65194. please help me with possible issue for this,
and we are showing the totals by using above option in expression tab. Thanks in advance.
Re: total not matching for one particular column in straight table...??
If you are using an if statement or some kind of manipulation such as Sum(A) * Sum(B)... the total row will calculate it's own set of calculation rather than doing sum of rows. To do manual sum of rows... look here Sum of rows in pivot tables. But since this is a straight table, we have a way to avoid using the Sum(Aggr()) function... which is to select Sum of Rows in total mode