data joining

[#1]

HI All

i have two a sales table (both have all same common fields)

1)i am taking sales based on Product Group table(sheet1)

2)now i need to include few sales based on product number table(sheet2)

i concatenated the sales in the dashboard

Product number is a drill drown group of Product Group

example

Product Group product number     Product Group Name

241                         241321                    Womens

241                         241322                    Womens     

241                         241323                    Womens

241                         241324                    Womens

241                         241325                    Womens

241                         241326                    Womens

there is a Common field between Product Group table and product number table  Product Group Name

in the dash board list box if i choose  Product Group name men

both sales common for Product Group Name should appear,

how to get this, please Suggest

[sunny_talwar]

There is no Product Group 241 in your attached Excel file (Sheet1)

Is that missing by mistake or that's how the data is?

[#3]

HI Sunny

this is how the data is actually

need only sales for few product numbers for the Product Group 241

[sunny_talwar]

But there isn't any Product Group 241 in your data provided?

[#5]

HI Sunny

the sheet 2 is for product group 241

but actually there are more than 100 product numbers fall under the Product Group 241

but only need the sales for 25 product numbers in sheet 2

(actual requirement is to see all the sales for (women) including Sales picked by sheet 1 and Sheet 2)

Please Suggest

[sunny_talwar]

May be concatenate sheet2 into sheet 1 where you can use

Concatenate (Sheet1)

LOAD Left([Product Number], 3) as [Product Group],

          [Product Number],

          Channels

FROM Sheet2

Where Match([Product Number], .....);

[#7]

HI Sunny

actually 241321

             241322

these first 3 digits are not the  Product Group i created it in that format as example

[sunny_talwar]

I am not really sure I understand what you are trying to do. Can you try re-explaining your requirement?

[#9]

I really didn't understand...

What do you want? Do you have I real database?

If you just want to click in WOMAN and QV show all sales for woman including sheet2 the base is wrong...

You can do all calculations in QV, don't need the "sheet2".

But check this .qvw, I don't know if it is what you want.

Giba

[#10]

HI Sunny

i will explain it clearly