 Rank: Newbie
Groups: extranet\Forum
Joined: 6/30/2017(UTC)
Posts: 3
|
I am trying to make a criteria, which is only active for some values of another dimension. In the following crosstab I would like to exclude [Code] " 23 SUPPL." if [Country] is " Germany" [img=http://drive.google.com/file/d/0BwvVEZDdK-4zT3IzSTY2TWdJeFE/view?usp=sharing]CombinedCriteria[/img] Please copy to browser if image is not visible; https://drive.google.com...TWdJeFE/view?usp=sharingI cannot find a way to eclude ONLY the combination of the 2.
|
|
|
|
|
|
 Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
Hi Mikkel
If you want to hide one specific row, then it is possible via
Properties -> Visibility -> Dimension values -> Hide a range of … -> Specific element
Choose the element Germany – 23 SUPPL and choose Apply
NB be sure to choose the row in the code column, otherwise you will hide all Germany.
NB hiding a row does not affect the grand total. If it is important that the sum of all visible rows is reflected in the grand total this has to be handled separately. |
Best regards
Páll, CTS |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 6/30/2017(UTC)
Posts: 3
|
Hi Páll, Thanks, That works when the values are visible. I was hoping for a criteria to also use "behind" the visible data. Do you have a suggestion for that as well? For example if I need to see a master total or a country total without the details https://drive.google.com...RjlZV0U/view?usp=sharing/Mikkel
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
OK. If you do not want to show Country and Code in the crosstab, then I would create a comparison with two elements, like this:  Then I would make a calculation subtracting the excluded set (in your case Germany & all 23 SUPPLY) from the total. Hide the intermediate columns. Here you can see an intermediate screenshot showing all the Quarters  Edited by user Tuesday, July 4, 2017 12:06:52 PM(UTC)
| Reason: Not specified |
Best regards
Páll, CTS |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 6/30/2017(UTC)
Posts: 3
|
That is actually how I solved it some time ago.
It just makes things a little slow...
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.