Drill Down Totals

[kgcognos]

I want to display the following rows and column in my crosstab. Drill down is enabled for Cust 123 only.
                     2016 Sales
All Customer    1,000,000                 ( I dragged the customer hierarchy and inserted just the single member)
   Cust 123         500,000                 ( I dragged Cust 123 and inserted just the member)

When I drill down to Cust 123, the All Customer total changes.
How to code so that All Customer will always contain the total Sales for ALL CUSTOMERS?

Thank you in advance. 




       

[MFGF]

I want to display the following rows and column in my crosstab. Drill down is enabled for Cust 123 only.
                     2016 Sales
All Customer    1,000,000                 ( I dragged the customer hierarchy and inserted just the single member)
   Cust 123         500,000                 ( I dragged Cust 123 and inserted just the member)

When I drill down to Cust 123, the All Customer total changes.
How to code so that All Customer will always contain the total Sales for ALL CUSTOMERS?

Thank you in advance.

Hi,

Instead of dragging in the hierarchy and selecting "Root members", open the Members folder in the package tree and drag in the very top member of the hierarchy (the All Customer member).

MF.

[kgcognos]

It was still changing when dragging the first member.
I used the ancestor function. It's now working.
Thank you