Need Dimension wise filter results

[khasimvali85]

Dear Community,

i have data and i need filter wise data i couldn't find out.

my requirement is i want out put like from each brand i need perteculer product.

Only selected products for brand wise

Ex: Brand         Product

    Samsung      Colour Television

    Samsung      Refrigerator

    Samsung      Washing Machine

    Onida            Colour Television

    Onida            LCD

    LG                Refrigerator

    LG                Washing Machine

    Kenstar        Colour Television

    Kenstar        LCDP

    Sansui          Colour Television

    Sansui         Refrigerator

    Sansui         LCD

    Daikin          Air Cooler

    Daikin          LCD

    Kelvinator    Refrigerator

    Kelvinator   Washing Machine

if i given the condition all product column will change, attaching sample file.

can anybody give suggestion

Regards,

Khasim.

[vikasmahajan]

what exactly you are looking for  Each brand you want top nos ?

[vikasmahajan]

you can take list box and add brand in list box when user select particular brand only that will display in report see attached qvw.

Vikas

[Anonymous]

Put your brand in one list box and Product into other list box..

as a selection indicator..then you can select any brand as per ur requirement

[khasimvali85]

Hi Vikas,

i want this report in Pivot Table

Regards,

Khasim.

[khasimvali85]

Hi Balraj,

Thanks for Reply!

my report not like this, i don't want  in list boxes. i need this report in pivot table.

[Anonymous]

Create a drilling of your Brand and Product Dimension

[khasimvali85]

Hi,

How could i do for drilling ?

[Anonymous]

Goto Dimension tab

Click on Edit Groupson the Bottom left side then create a drill group of your dimension.

Give a name of Group say Product_Brand Drilling and add your dimension as in your case

Brand

Product

like this..

[Anonymous]

and then use your created group say Product Brand Drilling as a dimension in your pivot table