Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See the attachment
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