Incorrect counts

[bhuprakash]

Dear all,

I am getting the incorrect count in my pivot table.

For example below 14 territories have total 13 activity count but this 13 is reflecting in all the territories. It should be sum total for all.

[prieper]

Go to Properties -> Presentation -> Dimensions and Expressions

choose "Mkt Territory Id" and click to "Show Partial Sums"

HTH

Peter

[bhuprakash]

Hi Peter,

It is not working.

[prieper]

What does not work?

It shows the Sum of 503 in the bottom-line??

[bhuprakash]

territory wise count should come as below. But it is coming wrong in my dashboard.

Marketing Territory	Count of Activity Id
Abohar	11
Achanta	1
Agar	8
Ambala	3
Amod	1
Amreli	1
Arvi	5
Athagad	2
B.Kothakota	1
Badnagar	4
Badnawar	6
Bagepalli	1
Baglan	13
Baleshwar Sadar	2
Barasat - I	2
Bareilly	3
Barpeta	1
Basudebpur	1
Bavla	1
Bemetara	3
Bhadrak Rural	1
Bhanvad	1
Bhuj	1
Binika	3
Biswanath	2
Bongaigaon (Pt)	1
Botad	4
Budhlada	1
Burdwan - I	1
Chakur	2
Challapalle	2
Chandvad	3
Cherukupalle H/O Arumbaka	1
Chhatarpur	1
Chikkaballapura	1
Chilakaluripeta	1
Chinaganjam	1
Chintamani	1
Dabhoi	1
Darsi	2
Deglur	2
Dewas	2
Dhar	1
Dharampuri	7
Dharangaon	1
Dhrol	2
Dhule	1
Diamond Harbour - I	1
Digras	3
Domkal	3
Edlapadu	2
Erandol	1
Faridkot	1
Fatehabad	10
Firozpur	3
Galsi - I	1
Galsi - Ii	1
Gampalagudem	1
Gangakhed	1
Gangapur	4
Giddalur	1
Gollaprolu	3
Gondiya	1
Gudivada	1
Gudlavalleru	2
Halvad	1
Harda	2
Himatnagar	1
Hingoli	1
Hisar	5
Ibrahimpatnam	2
Jafferabad	1
Jagadhri	3
Jagraon	9
Jaleswar	1
Jalgaon	1
Jamnagar	1
Jasdan	1
Jayapatna	1
Jaynagar - Ii	1
Jintur	2
Junagadh	1
Junagarh	2
Kaikalur	1
Kajuluru	4
Kakching	1
Kalavad	1
Kallur	3
Kalna - I	8
Kalwan	8
Kanaganapalle	1
Kannad	5
Kapileswarapuram	3
Karapa	5
Karnal	5
Kavali	1
Kavathemahankal	4
Khacharod	2
Khajipet	1
Khambhalia	2
Khandaghosh	1
Khanna	2
Khategaon	4
Khedbrahma	1
Kheralu	1
Kichha	2
Kirlampudi	3
Korukonda	1
Kosigi	7
Kothapalle	3
Kuttanad	3
Latur	1
Limbdi	1
Mahesana	1
Malhargarh	1
Malout	2
Mamidikuduru	2
Manawar	3
Mandapeta	2
Mandsaur	2
Mansa	6
Manteswar	1
Mantha	1
Martur	1
Mauda	2
Mehkar	1
Memari - I	1
Moga	2
Mohol	1
Mopidevi	1
Muktainagar	1
Nadendla	2
Nagaram	1
Naidupet	3
Nandigama	6
Nandurbar	1
Narasaraopet	3
Nashik	6
Nilokheri	7
Niphad	2
Okhamandal	2
P.Gannavaram	2
Paithan	1
Palam	1
Pamarru	4
Panipat	5
Parola	1
Partur	1
Patti	3
Pedana	2
Pedaparupudi	3
Pedapudi	1
Pedda Thippasamudram	1
Pehowa	2
Penuganchiprolu	4
Pipariya	2
Pithapuram	2
Ponnur	1
Punganur	1
Raina - Ii	1
Rajanagaram	1
Rajkot	1
Rampur	1
Rampura Phul	3
Ranpur	1
Ratlam	8
Rayavaram	3
Razole	1
Rentachintala	1
S.Mydukur	1
Saharanpur	1
Samalkota	3
Sangamner	1
Sangrur	1
Sankhavaram	1
Sardulgarh	3
Sawer	1
Seethanagaram	1
Sehore	2
Shahade	1
Shahbad	5
Shirpur	1
Shivpuri	7
Sillod	1
Sirsa	7
Sonipat	19
Srinivaspur	1
Talala	1
Tenali	3
Thanesar	2
Thiruvallur	1
Tiruvuru	2
Upleta	1
Uppalaguptam	1
Vadali	1
Vaijapur	1
Vanthali	2
Vatsavai	1
Veldurthi	3
Venkatagirikota	6
Vijapur	1
Vijayawada (Rural)	2
Wadhwan	1
Warud	1
Washim	3
Yemmiganur	8
Zira	5
Grand Total	503

[prieper]

put in the field "Marketing Territory" and you will get the count as above?

[bhuprakash]

Hi Peter,

Not able to do so. Can you please do it for me in the attached file ??

[prieper]

Just change the content of the pivot ...

You asked for something, but in the pivot you calculated on a different dimension...

Peter

[bhuprakash]

Thanks Peter.

But If I am adding Sales Territory with this data then counts are just getting repeated.

Kindly check this.

[prieper]

Dear,

the formula is correct, but think that there are some odd relations in your datamodel.

Suggest to solve the problem first in Excel and see what is inside.