Drill Down problem

[#1]

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

I

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.

[IAMDV]

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

Thanks,

DV

www.QlikShare.com