pivot table total

[fabdulazeez]

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

[petter]

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

[fabdulazeez]

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

[petter]

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?

[fabdulazeez]

Yes.

Contribution cur year.

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

[petter]

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?

[fabdulazeez]

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.

[fabdulazeez]

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