Show multiple lines of data under each dimension on straight table/pivot table

[Dayna]

Hello All,

I have no idea if this is possible, either a straight table/pivot table, or whatever you think, but I'd like to show mulitple lines of data under each dimension in a table.

I.e. our main value is 'Product', so I'd like my table to look like the following

PRODUCT

     PRODUCT LOCATION      |     PRODUCT QUANTITY     |     PRODUCT STATUS

PRODUCT1

     PRODUCT LOCATION1    |     PRODUCT QUANTITY1   |     PRODUCT STATUS1

PRODUCT2

     PRODUCT LOCATION2    |     PRODUCT QUANTITY2   |     PRODUCT STATUS2

etc...

Could you advise on how I could achieve this?

Kind Regards,

Dayna

[#2]

See the attachment

[Dayna]

Hello,

Many thanks for your response. Basically what I'm trying to achieve is use 'Product' as the heading, then have a row underneath that would have 3 or so columns, but only using one row of space.

I tried doing this with a pivot table, but I wouldn't want the expression headings to show..

Just the heading, then the dimensions below. Another example would be:

PRODUCT

DESCRIPTION      |          STATUS     |     PRODUCT MANAGER

PRODUCT

DESCRIPTION      |          STATUS     |     PRODUCT MANAGER

PRODUCT

DESCRIPTION      |          STATUS     |     PRODUCT MANAGER

etc...

Kind Regards,

Dayna