Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Here is a sample qvw.
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.
Hey Bill.
Let me check your file..
thank you.
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
Thank you Bill.
Works perfectly... great job!!