en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Mikkel Holmgaard  
#1 Posted : Monday, July 3, 2017 2:03:19 PM(UTC)
Mikkel Holmgaard
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=sharing

I cannot find a way to eclude ONLY the combination of the 2.
Páll Bjarkason  
#2 Posted : Tuesday, July 4, 2017 8:36:57 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 182

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
Mikkel Holmgaard  
#3 Posted : Tuesday, July 4, 2017 9:42:55 AM(UTC)
Mikkel Holmgaard
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
Páll Bjarkason  
#4 Posted : Tuesday, July 4, 2017 12:03:04 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 182

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:
UserPostedImage


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
UserPostedImage

Edited by user Tuesday, July 4, 2017 12:06:52 PM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Mikkel Holmgaard  
#5 Posted : Monday, July 10, 2017 1:30:58 PM(UTC)
Mikkel Holmgaard
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...
Users browsing this topic
Anonymous
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.

Notification

Icon
Error