IS there any way to define our own custom expression to define totals in straight table .
I have a strange requirement where i neeed to calculate Totals in which i have drilldown .I have three levels in drilldown .
Store
Department
Section.
My requirement is if i drill down to department totals for store should be displayed but data should be for deparment only.
And same for the section also.For both Dept and Section totals should be Store .
IS there any way to achievve
Thanks
