Has anyone come across a possible bug when creating subtotals for a pivot table? I have a table and the partial sums is giving the wrong answer? This only occurs in one of 4 tables. In the table below, the total on the right is fine but the subtotal for each country is incorrect.
type
FRANCE
GERMANY
SPAIN
UK
HUNGARY
POLAND
Total
A
15,571,408
3,244,873
16,610,151
26,766,687
1,714,269
10,255,721
74,163,110
B
1,318,604
1,134,547
4,442,907
8,557,572
1,508,499
841,247
17,803,376
C
0
0
0
47,256
0
0
47,256
D
1,750,967
4,223,077
5,944,194
4,586,050
0
0
16,504,288
E
(208,902)
(3,134,593)
(5,035,153)
(7,844,530)
0
0
(16,223,177)
F
0
0
0
(52,157)
0
0
(52,157)
G
(1,303,678)
(46,407)
(9,716)
(839,271)
(327,287)
0
(2,526,359)
H
(4,861,895)
(1,664,617)
(987,598)
(2,663,852)
(666,163)
(106,348)
(10,950,474)
I
(4,538,203)
(471,540)
(2,214,150)
(2,773,284)
(53,810)
(24,315)
(10,075,302)
J
0
12,901
0
0
0
0
12,901
Total
100,597,010
32,664,830
164,739,054
274,378,104
21,502,014
105,706,966
699,587,978
I've tried recreating it but still coming up with odd results. Any ideas why it doesn't sum the columns as expected?
Something is wrong in the way your data model is linked or joined. Strangely the countries have totals about 10 times more than their real total and their are 10 types.
I suspect that this is due to the expression and/or dimension you're using. If you upload a reduced copy of the document that would be helpful in checking.
(My guess would be that the expression contains an if() statement of some sort)
