Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Morten Davidsen  
#1 Posted : Thursday, June 2, 2016 8:58:51 AM(UTC)
Morten Davidsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 3/2/2015(UTC)
Posts: 10


Is there no way in TARGIT to create "or clauses" across different dimensions? (and I don't want to include the dimensions in my table, to do some kind of calculation to fix it).

See detailed example below.
Thank you in advance.

Imagine I have this data:
[dimension_a], [dimension_b]
X, Z
T, Y
T, P

Is it possible in any way with TARGIT to do something like the following as criterias:
if dimension_a = 'X'
dimension_b = 'Y'

Once I have filtered dimension_a to 'X', it can't see 'Y' no longer. If I unselect "don't filter list", it will show 'Y', but still the data is not being shown (for T, Y row).
Niels Thomsen  
#2 Posted : Friday, June 3, 2016 6:27:23 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 110

Hi Morten

The default setting in TARGIT is AND - the only exception to the rule is that when you choose to values from the same dimension it will effectively work as an OR.

Customer A and Item B = AND (different dimensions)
Customer A and Customer B = OR (same dimension)

I don't think there is a workaround currently.

It would be great if you could take the time to formally suggest this in our new forum: Uservoice

Hope it makes sense.

Best Regards
Niels Thomsen


Users browsing this topic
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.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.