Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Kumar,
See attached solution.
Regards,
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