COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 06 Sep 2011 01:38:24 PM

Title: different aggregation at different subtotals
Post by: barrysaab on 06 Sep 2011 01:38:24 PM
I have a list report which is developed by using sql query,i have multiple subtotals in it such as Stores sales by products region wise,and countrywise and then summary wise.my requirement is the end user want to apply different type of aggregations at these subtotals such as for region wise subttotals he want it to be actual/budget and for countrywise some other logic. How can I apply these different aggregation logic in all different subtotals.Thanks.