COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: franky1241 on 29 Oct 2012 12:48:43 PM

Title: Cross Tab Drill Through works on not-aggregated, but not work on aggregated
Post by: franky1241 on 29 Oct 2012 12:48:43 PM
Hi, users

I have a cross tab report. I changed "Define Contents" to "Yes" and was able to create drill-through to a detailed report. The data only has two one values: 1 and 0. If I reply on default "Aggregate Function" to be "Total" and "Rollup Aggregate Function" to be "Automatic", the drill-through return no result. If I change "Aggregate Function" and "Rollup Aggregate Function" to be "None", the drill-through return correct result.

However, I do need to show the aggregated number on the parent report. Any ideas, tips? Thanks a lot for your help in advance.

Franky