Singleton and Crosstab difference

[RL_Boston]

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!

[PRIT AMRIT]

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.

Can you explain more about your requirement?

[RL_Boston]

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.

[PRIT AMRIT]

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.

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