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

[#2]

John,

Your data tables are not designed such that you can make any meaningful relationship between them.