Running-count / RowNumber in Crosstab for Individual Members

[Chamopak]

Hi,

I have this cross-tab report build complete out of Individual members.  This will have zero suppression.
Is it possible to use running-count or RowNumber on the rows that the report will display?

Summarize:
1. Crosstab report
2. Rows build complete out of individual members.
3. Will use zero suppression to eliminate 0 values
4. number the displayed rows automatically


Thank you in advanced for your knowledge sharing!

[MFGF]

Hi,

I have this cross-tab report build complete out of Individual members.  This will have zero suppression.
Is it possible to use running-count or RowNumber on the rows that the report will display?

Summarize:
1. Crosstab report
2. Rows build complete out of individual members.
3. Will use zero suppression to eliminate 0 values
4. number the displayed rows automatically


Thank you in advanced for your knowledge sharing!

Hi,

You didn't state whether you are using a dimensional or relational package. Given your reference to members I'm assuming it's dimensional?

If so, you will probably need to move away from using zero suppression and instead use a filter function in a query calculation to deliver your set of members (or each member) - filtering for >0. You will probably need them in a set anyway so putting them in a set with a set() function, filtering this set using a filter() function then counting across the members of the set is probably the way to go.

MF.

[cognos810]

Hello Chamopak,
Select your individual node members, hit "Unlock" on the top. Then drag and drop a "Layout Calculation" to the left of your existing member caption for the data item in the node. The expression to put into the layout calculation is:
RowNumber()
If you need a separator, between your row number and the member caption, drag and drop a test item in between the layout calculation and the member caption for the data item in the node.

-Cognos810