![]() ![]() ![]() (Thus enabling me to quickly see what other products those sales people have sold.) Is there any way I can filter, so that I will see only those sales people who have sold 3 tables or more lets say. table, chair couch, and the Values are the total number of that item sold. ![]() The resulting PT has 3 columns, for each of the products - e.g. Using the example of a list of salespeople and their transactions over the year, who sell multiple products, the PT is Sales Person name for the Row Labels, and Type of Product for the columns. One thing that I just can't figure out though, is if there is some way to filter based on the value in a specific subcolumn. This site has been really useful - thanks! Hi all, I've just immersed myself in PivotTable for the first time this week, and am more or less getting the hang of it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |