If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Retain TopCount on Drill Down

Started by Corrigon, 05 May 2016 09:25:11 PM

Previous topic - Next topic

Corrigon

Hi there, I have a crosstab report where the left edge uses a data item containing a TopCount expression for Parent Customer Accounts. There is also a filter expression excluding nulls against the Value measure.

The hierarchy I am using has Grandparent - Parent - Customer as levels.

When I drilldown on a Parent Account, it displays the Customer accounts but they include nulls, and those Customers with values are not ranked.

How can I set the drill down to retain the same TopCount and filter expressions as used in the Parent data item?

Thanks in advance for any and all responses.

Cheers,
Dave