BEx Query Hierarchy Result Cells with No Zero Suppression + Drill Down Characteristic

[murcielago83]

Hi all,

I've a BEx query (No Zere Suppression for Rows) that shows hierarchy for Accounts (show result never). In the free char i've Account Numb (show result never).

if I drill down the free char Account Number, then:

The row "CO" haven't Account Number value, but it show the Result cells in yellow without value.

I don't want show Result cells in yellow, but however i want show the row "CO".

Is there a way to change this behavior?

Below an example that I want show (modified with paint)

Thank you.

[john_hawk]

Please show the properties of the hierarchy and the query for results rows, as shown in the query designer.

[murcielago83]

Hi John,

please check this properties:

Query

Hierarchy

Thank you