G
Guest
Guest
Dear sirs,
multiplying figures with percentages in a pivot table leads to the right result in the line, but the total total provides a wrong value; example:
10 * 20% = 2 => o.k.
20 * 30% = 6 => o.k.
30 * 50% = 15 => this would be ttl total,
because the percentages would be added.
How is it able to hide the ttl of the percentages (50%) and to get the right result of 8 in the end ??
Many thanks in advance..
multiplying figures with percentages in a pivot table leads to the right result in the line, but the total total provides a wrong value; example:
10 * 20% = 2 => o.k.
20 * 30% = 6 => o.k.
30 * 50% = 15 => this would be ttl total,
because the percentages would be added.
How is it able to hide the ttl of the percentages (50%) and to get the right result of 8 in the end ??
Many thanks in advance..