 Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/11/2017(UTC)
Posts: 15
|
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
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 433
|
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.  Ole Dyring |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/11/2017(UTC)
Posts: 15
|
Thank you very much Ole!
Exactly what I needed... and I would not have figured this out myself.
|
|
|
|
|
|
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.