en
Welcome Guest! To enable all features please Login or Register.
Options
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

Hi,

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'
or
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: 103

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

https://dk.linkedin.com/in/ncthomsen


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