4/7/2023 0 Comments Excel for mac 2011 slicersUse Data, Remove Duplicates to create a unique list of the sectors found in either table.īuild a third table to be the source for the slicer If both of your data sets contain a field called Sector and you want the pivot table to be based on Sector, copy the Sectors from both tables to a new table. The key step is to build a new SlicerSource table. The data model is easier than the VBA solution.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |