Filtering entire data model by 1 column

[heidiatmn]

I am new to this so please bare with me. I have made a data model with 3 tables-sales, budget info, detailed customer info (including rep). They are all linked together by customer number. All good. Now I'd like to make multiple spreadsheets from this "master" that filters on a rep number (on the customer info table). Is there a way to easily do this? Even if you just provide me what this would be called so I can search? I've been striking out. Thanks!

 

[GlennUK]

Create a PivotTable. Have all the information and row items and columns you want to report, and put the Customer Number in the PivotTable Page Filter area. You can filter by required Customer. Be aware that there is a PivotTable command on the menu, Analyze/PivotTable/Options/Show Report Filter Pages, which will create a new tab per item in the filter, if that is what you are aiming for.