Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: RL_Boston on 01 Apr 2011 02:55:27 PM

Title: Singleton and Crosstab difference
Post by: RL_Boston on 01 Apr 2011 02:55:27 PM
Hi -
I have a Crosstab and I am trying to show the Total value within a Singleton. However, the Singleton value is less than the Total. Has anyone gotten this and how to troubleshoot/fix?

Thanks!
Title: Re: Singleton and Crosstab difference
Post by: PRIT AMRIT on 07 Apr 2011 01:43:39 AM
QuoteI have a Crosstab and I am trying to show the Total value within a Singleton. However, the Singleton value is less than the Total.
Can you explain more about your requirement?
Title: Re: Singleton and Crosstab difference
Post by: RL_Boston on 07 Apr 2011 07:42:54 AM
Say my crosstab is to show the details for amount of products sold per month. Then I have the Totals at the bottom. I am trying to show the Total(total(product)) in a singleton on another page.  But when I do this the number is not the same.
Title: Re: Singleton and Crosstab difference
Post by: PRIT AMRIT on 07 Apr 2011 11:53:11 PM
QuoteI am trying to show the Total(total(product)) in a singleton on another page.  But when I do this the number is not the same.

Total(total(product))-- For this, are you considering all the dimensions which you might have in your cross-tab report? In short, your Singleton query should look similar as your Cross-tab query.

BTW, what is the expression for 'Total(total(product))' you have defined?

Thanks
Text only | Text with Images