Drill Down Group

[#1]

Dear team.

I would like your help regarding a doubt with Drill Down Option.

Let’s use the following dimensions in a Chart

- yearMonth / Drill Down Group (Brand > Region > District > Dealer)

When I have more than one brand do the drill down works perfectly and show me the amount of sales by each dimension, but if I have only one brand, this information is not showed and the drill down starts with Region.

Is it possible to force the drill down by brand even when I have only one Brand?

Thank you.

Regards.

[Anonymous · Accepted solution]

Try adding a dummy Brand of null().  Then you'll have 2 brands, you can set it to not display the null() and it should work as you wish.

[Anonymous]

Here is a sample qvw.

[#4]

Thank you Bill for your answer.

I'm not sure if I'm doing it in the right way, so let me resume: I Load the qvw with Brand1 values only.

Then i change the Drill Down group and I insert the following expression for EOM dimension:

=if (OEM = 'Brand1', OEM, Null() )

Didn't work. 

Thank you for your help.

[#5]

Hey Bill.

Let me check your file..

thank you.

[Anonymous]

The load script I used was :

Data :

LOAD * INLINE [

    Dim1, Dim2, Exp

    A, Q, 1

    A, W, 2

    A, E, 2

    A, R, 4

    A, T, 5

    A, Y, 6

    A, X, 7

    A, W, 2

    A, E, 2

    A, R, 4

    A, T, 5

    A, Y, 6

    A, X, 7

];

Load

null() as Dim1 ,

null() as Dim2 ,

null() as Exp

AutoGenerate 1

;

As the fields are the same the second load with the dummy Nulls will concatenate onto the real data

[#7]

Thank you Bill.

Works perfectly... great job!!