Forum Discussion
need help showing multiple values based on a drop down
Hi all, I need to send out a spreadsheet where a user can see a product, product category, and all subcategories for that item (see attached for what I have in mind). I think a pivot table is th...
Hello Haytham, Thank you for your response. I am actually not looking for the sum, or count- I'm looking for the product to display the way it is in my attachment. If a product is an apple, I need it to display both Fruit and Red and Green. I don't care if it's in the same column or different columns, but I need to display both subcategories. Does that make sense? Thanks Marlise
Hi Marlise
Bit late to this conversation but I think the trick you need is to go to Design > Report Layout > Show in Tabular form
Then next to that button is Subtotals > Do not Show