![](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i76a602719c30d93a/version/1525354855/image.png)
Here is a short post about something I just found and never used until now. You can create restrictions in Analysis Office by either using the context menu of a measure or via the ribbon menu entry under Calculations >> Add Restrictions. It will display a new dialog where you can define your restrictions.
![Analysis Office Add new restriction](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i7d4213f480cf68bc/version/1521487074/analysis-office-add-new-restriction.png)
You have to define a name, a based on measure and your selection(s). After you defined your parameters, click OK and a new column will be added to your crosstab.
![Crosstab with Restriction](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i1b6a0f6d8301ad89/version/1521487092/crosstab-with-restriction.png)
As you can see the restriction just show I have defined on my selection in the dialog above. I hope this could help someone.
These posts might also be interesting:
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)
Write a comment
Alex (Friday, 12 March 2021 15:38)
That's really nice.
But unfortunately one cannot use restrictions on measure with objects, which are used in the measure definition in the query, right?
Tobias (Wednesday, 17 March 2021 11:25)
Hi,
you mean the infoobject of a restricted key figure in a query? You need the infoobject you want to restrict at least in the free characteristic area. Is that what you mean?