Crosstab Totals

[gosoccer]

Folks,

I managed working with the Cross tab to come up with two different Crosstab Spaces to show two different counts.

Now, I need to have the Totals established for each of the two columns as the snapshot shows.

The Total function in Report Author is getting very confused... to be honest.

I'm thinking to create the Crosstab Space (With Fact Cells) and have a Data Item created with the Total and drop it in
this space.

Let me know what you think?

THx alot for your time.

[Cognosuser2019]

I am working on a similar thing and was able to achieve it. Just click on the crosstab header (node member) and click on Summarize Total. It should create the total column.

See attached for where to place the selection. See if it helps.

[gosoccer]

Thx for the reply.

I keep getting this error:
XQE-GEN-0005

      Found an internal error:
java.lang.NullPointerException

What's your source type for the column node?

[Cognosuser2019]

Not sure on the error. My source type for the column node is Member Caption.

[MFGF]

Folks,

I managed working with the Cross tab to come up with two different Crosstab Spaces to show two different counts.

Now, I need to have the Totals established for each of the two columns as the snapshot shows.

The Total function in Report Author is getting very confused... to be honest.

I'm thinking to create the Crosstab Space (With Fact Cells) and have a Data Item created with the Total and drop it in
this space.

Let me know what you think?

THx alot for your time.

Are the Zones all of the zone members or just specific ones? If they are all the zone members, you could simply drag the "All Zones" member into the crosstab and nest your calculated measures beneath?

Cheers!

MF.