Pivot table not displaying totals and subtotals

[#1]

Hi...

I am trying to get the totals and subtotals in the pivot table. It displays for certain fields but not for all. I dont know what I am doing wrong here. I have attached the file. Can somebody please help me out here??

Thank you.

Regards

Kumar

[Anonymous]

Kumar,

Total can be shown only for aggregations. For example sum() or count(). Or expression like "Expression A" / "Expression B" where both are aggregations.
The totals are missing in your table when expressions are like if(<condition>, <aggregation>) because they can't be defiened. Try to modify expressions, maybe using aggr:
sum(aggr(<your current expression>), dimensions)

[vgutkovsky · Accepted solution]

Kumar,

See attached solution.

Regards,

[#4]

Thanks Michael for your inputs

Thanks a lot Vlad....you saved me a lot of trouble...i was planning to use a table with manually totalling stuffs...Just dint know about the aggregation part in pivot table.

Regards

Kumar