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.

[Anonymous]

Please see the attachment.

Hope this will help!!

[khasimvali85]

Hi Balraj,

This report will show only Brand wise and all product wise

my report is given like

i need to selected products for brand and i don't want all products for brand

      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

[Anonymous]

  This is the data you are having in your QV, rite?

Then how do you want to present it?

or in the same way you want to represent???

[vikasmahajan]

you can use drop down select see attached file

HTH

vikas

[khasimvali85]

Hi Vikas,

If we do drop down the all data will change.

please see the new attached QVW file for my output.

[Anonymous]

For this you need to hard code it..

Like you can add a calculated dimension like

If(Brand='DAikin', if(Product='Air Cooler' or Product='LCD', Product),

if(Brand.......like this...

[Anonymous · Accepted solution]

PFA..

you need to do it for all the others.

[jagan]

Hi,

Try like this

LOAD BRAND,

     PRODUCT,

     Value,

     If(WildMatch(BRAND, 'Samsung') AND WildMatch(PRODUCT, 'Colour Television', 'Refrigerator', 'Washing Machine') OR

     WildMatch(BRAND, 'Onida') AND WildMatch(PRODUCT, 'Colour Television', 'LCD') OR

     WildMatch(BRAND, 'LG') AND WildMatch(PRODUCT, 'Refrigerator', 'Washing Machine') OR

     WildMatch(BRAND, 'Kenstar') AND WildMatch(PRODUCT, 'Colour Television', 'LCDP') OR

     WildMatch(BRAND, 'Sansui') AND WildMatch(PRODUCT, 'Colour Television', 'Refrigerator', 'LCD') OR

     WildMatch(BRAND, 'Daikin') AND WildMatch(PRODUCT, 'Air Cooler', 'LCD') OR

     WildMatch(BRAND, 'Kelvinator') AND WildMatch(PRODUCT, 'Washing Machine', 'Refrigerator'), 1, 0) AS Flag    

FROM

BRAND_PRODUCT.xls

(biff, embedded labels, table is [Sheet1$]);

Now in front use below expression

SUM({<Flag={1}>}Value)

Hope this helps you.

Regards,

Jagan.