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!
Quote from: Chamopak on 02 Jun 2015 08:37:21 PM
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.
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