en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lenka Eriksen  
#1 Posted : Monday, September 4, 2017 11:12:54 AM(UTC)
Lenka Eriksen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/11/2017(UTC)
Posts: 10

Hi,

I have a simple crosstab with 1 vertical & 1 horisontal dimension. Some combinations of these 2 dimension are ok, others are a mistake which I would like to highlight by color agent. Measure is document count.

A B C
1 100 10 0
2 125 0 5
3 5 200 0
4 0 250 5

So e.g. for horisontal dimension's value A, only vertical dimension's values 1 & 2 are ok, others non-zero/blank are mistakes to be highlighted. Then column B dimension values shouldn't have any values in rows 1 & 2, only 3 or 4 are correct combinations.

I've tried with count(d1:0, d1:0, m1) = count(d1:@"[A]", d1:@"[3]", m1) but no luck.

Any suggestions?

Lenka


Ole  
#2 Posted : Monday, September 4, 2017 11:34:39 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 385

Hi Lenka,

For your syntax, you should probably try something like this instead:

allcount(d1:0, d1, m1) = allcount(d1:@"[A]", d1, m1) and allcount(d1, d1:0, m1) = allcount(d1, d1:@"[3]", m1) and value <> 0


BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Lenka Eriksen  
#3 Posted : Monday, September 4, 2017 12:13:23 PM(UTC)
Lenka Eriksen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/11/2017(UTC)
Posts: 10

Thank you very much Ole!

Exactly what I needed... and I would not have figured this out myself.
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