Drill Down problem

Fri, 13 Jul 2012 08:03:33 GMT

Hi Everyone,

I need to have drill down in this manner Market --> Product --> FormStrength

The problem is that I am able to get that thing in listbox but I want the same in straight Table.

I am using these expressions for drill down in list box:

Market

aggr(Only({1<Market= P(Market),PRODUCT= >} PRODUCT),PRODUCT)

aggr(Only({1<PRODUCT= P(PRODUCT),FORMSTRENGTH= >} FORMSTRENGHTH),FORMSTRENGTH)

I am getting the Right result

The Same thing I want in Straight Table in three coumns like this

Market1 product1 FM1

FM2

FM3

product2 FM1

FM2

FM3

In listbox, formstrength is coming for but both possible as well as excluded.

I want the same in Straight table.

Re: Drill Down problem

IAMDV — Fri, 13 Jul 2012 08:44:54 GMT

Please can you post an example with sample data? It makes it easy to answer.

Thanks,