7 Replies Latest reply: Mar 25, 2018 8:00 AM by Fawaz Abdul Azeez

# pivot table total

When I am using total function, it is showing total for all columns. how can i find total specific to each column.

• ###### Re: pivot table total

Could you illustrate by giving us a screenshot or example of what you are looking for?

• ###### Re: pivot table total

Here i need to find contribution. So i am using total function. but it gives sum for both columns(1463 & 5437). i need total for rows for each column

• ###### Re: pivot table total

So you need to get the Contribution measure correct - right?

How does the calculation of the contribution look like if it was done on a spreadsheet?

• ###### Re: pivot table total

Yes.

Contribution cur year.

Sum(curyear)/ Sum(total <  itemgroup> curyear)

• ###### Re: pivot table total

I don't have a clear understanding of your problem.... is it possible to rephrase it? What is wrong and what do you want to get?

• ###### Re: pivot table total

sorry for not being clear.

Even if I am using Total qualifier with ITEMGROUP(column), I get same value for both Item group.So to get total for each itemgroup what should be formula.

• ###### Re: pivot table total

I can get contribution when i don't have a column.Total<cust_cg_code> gets me total. but when i have column for ITEMGROUP Total<cust_cg_code,ITEMGROUP> IS GIVING SAME VALUE FOR BOTH ITEM GROUP