Sum not showing total per dimension

[Anonymous]

Hi,

Need help with the following problem.

I have a pivot table with the following fields:

Region	Branch	CompanyName	UserName	subs
Asia	China	ABC	John	5
Asia	India	FCG	John	5
Asia	Singapore	RDF	John	5

The user John has only 5 submissions. But the instead of showing the distribution per branch/companyName wise the sum(subs) is showing the total number of submissions in all the rows.

Kindly let me know how to get the sum of each row .

Thanks in advance

Regards,

Anupama Jagan

[sunny_talwar]

Seems like a data model issue... can you share a sample app where you can show us the issue?

[Anonymous]

Hi Sunny,

Thanks for your reply

I will create a sample app and share it soon. The confusion i have is when when i try sum(submission) for the given Region and Username the sum shows only 5 and not 15..

Its just duplicating in all rows.

[surendraj]

your requirement was not clear.but what my assumption is you want total submissions.

it works like...

sum(subs)=5

sum(Total subs)=15

[Anonymous]

Hi surendra,

I will make the requirement more clear. Currently for the user John the sum(submission) is 5. so when i show the following details in pivot table data is like this:

Region	Branch	CompanyName	UserName	subs
Asia	China	ABC	John	5
Asia	India	FCG	John	5
Asia	Singapore	RDF	John	5

But the required result is something like this:

Region	Branch	CompanyName	UserName	subs
Asia	China	ABC	John	2
Asia	India	FCG	John	2
Asia	Singapore	RDF	John	1

Instead of showing the distribution of the submission, 5 is getting duplicated in each row.

Now i hope the requirement is clear

[buzzy996]

hi,u have to clarify one more thing, on what basis ur data has spitted, for exp in ur data row1 sub =2-- how u got 2 here?