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