![]() One way to reduce the clutter is by introducing two-level filtering. This is because such fields have 100s of values usually. When using fields like customers or products, you cannot easily apply slicer or report filter on them. Related: How to use relationships to build multi-table pivots in Excel Idea #5 – Add two-level filtering by alphabets Once you have such a table, you can connect this product.types table to original data using relationships and then build a multi-table pivot.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |