I have a pivot table I generated from another table with a lot of data.
I was to have this table by supplier, so I know the sub-total I'm spending by supplier. But I also want to know some details about the products I'm buying from each supplier.
The problem is, playing around with the pivot table and its design, changing from compact-outline-tabular, the best design I could get so far is not good enough. I wan it in a tabular way apparently. However, each time I add a new info (a new column), the info is not only added in a new column, but also in a new row, under the line of the product it is referenced from. In addition to that, it generates duplicate values, that are not summed up in the totals, but generate a visual pollution. I need this table to be as simple as possible for anyone understand it and work with it.
excel sheet.jpg
How could I make the model, quantity and whatever else I decide to add to be in the same row as the product name?
Thank you! =)
Bookmarks