Drill down group level be skiped in bar chart

[#1]

I have a chart with a drill down group as dimension

Cat ---> Product ID

When i come to the bar chart , the chart skiped the Cat level  and directly display the level of ProductID

I want to have a option to drill from the Cat level ,anyone can help with that or any workaround solution ?

Here is the example

[kaushiknsolanki]

Hi,

   I dont know is this the pefect reason or not, but when you include one more value in Cat Field, say for example you have something like this

LOAD * INLINE [

    ProductId, Amt, Cat

    a, 10, Group

    b, 10, Group

    c, 10, Group

    d, 10, Group

    e, 20, Group2

];

The levels are shown as they are descirbed in the group.

Regards,

Kaushik Solanki

[IAMDV]

Hi,

Kaushik is right. You can need to include some psuedo value in your Cat Field and you can restrict the same in your expression. Then you will only see Group and not Group2.

SUM({$<Cat -= {"Group2"}>}Amt)

I am attaching a quick example.

Hope this helps!

Cheers - DV

[IAMDV]

Sorry - I haven't uploaded the correct QV document. Here is what you need...

Cheers - DV

[#5]

Thanks Brother. Information is helpful.

However ,my actual problem is more complicated

Because my fact and dimension table are seperated

I have created another example to simulate the case.

The Fact table may linked to different dimension. In my example is just product and customer

If i add the psuedo value ,i need to add to both fact and dimension in order to bring back my Group level in drill down .

And it need to add on every possible selection of the dashboard as well

e.g. In my example i need to add

    e,,C2

    e,,C3

    e,,C1

My working dashbard has about 10 dimensions ,if i follow the solution ,it will create huge amount of dummy data .It reduct the performanance

and i need to rewrite every expression to filter out the dummy data

Is there any workaround ?

[rwunderlich]

The way I handle this problem is to add a null() to each dimension that may have only one value. The nulls will be filtered out by default but will create the desired group behavior. See attached.

-Rob

http://robwunderlich.com

[IAMDV]

Rob - This is clever solution. And I think is the best workaround for this issue.

Many thanks again!

Cheers - DV