![Crosstab before Filter by Member Attribute](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i89af146a60b235b9/version/1514393572/crosstab-before-filter-by-member-attribute.png)
A feature which I didn't know even it is available since Analysis Office 2.2 is to search and filter by attribute. First select a dimension you want to filter.
![Filter by Member via Context Menu](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/if32c34372b91b360/version/1514393572/filter-by-member-via-context-menu.png)
Now you see the Filter by Member dialog and you can display the necessary attribute you want to filter.
![Filter by Member Dialog](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i409dfc0d03f24746/version/1514393572/filter-by-member-dialog.png)
Now select in the dropdown menu the attribute you want to filter.
![Filter by Member Select Attribute](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/ia8d6ec4956ff7706/version/1514393572/filter-by-member-select-attribute.png)
After you select the attribute, you can use the search bar to filter your result.
![Filter by Member via Attribute](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i4921abf2baeb3c42/version/1514393573/filter-by-member-via-attribute.png)
The result of the crosstab should look like the following screenshot.
![Crosstab after Filter by Member](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i372662b10bec9d8f/version/1514393573/crosstab-after-filter-by-member.png)
So as you can see, you cannot only Filter by Member for a dimension, you can also Filter By Member for an attribute. This might be interesting for you, when you use a lot of attributes.
author.
I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=jpg/path/s1c89cca4309ebad9/image/ifbcbd6254b84b440/version/1579612443/image.jpg)
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=png/path/s1c89cca4309ebad9/image/iceb7c340a3cdfd11/version/1547207729/image.png)
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=png/path/s1c89cca4309ebad9/image/i33303fc1b6cc6323/version/1522747916/image.png)
Write a comment
Maja (Wednesday, 19 August 2020 09:18)
Thank you, this was helpful to me!
JASV (Thursday, 22 June 2023 16:52)
Great Info. Thanks