 Rank: Newbie
Groups: extranet\Forum
Joined: 9/19/2014(UTC)
Posts: 4
|
Hi,
Is it possible in any crosstab to give certain columns (calculated or not) a different style (font, backgroundcolor, …)? With rows it works perfectly by using crosstab themes but with columns I don’t find how it works.
Thanks
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 497
|
Hi Brenda,
You will need to use a little calculations/color agent trick to do this.
Suppose you have three columns Asia, Europe and North America, and you wanted Europe to stand out with a different color. Then add a color agent,"Color background", with this condition:
allcount(d1:0, d1, 0) = allcount(d1:@"[Europe]", d1, 0)
The syntax may be a little more complex if your columns are made up of hierarchies, comparisons or multiple dimensions. Let me know.
Best regards, |
Ole Dyring |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 9/19/2014(UTC)
Posts: 4
|
Hi Ole,
Thanks for your answer. I've tried it and it works.
Now I also want to give a different style to subtotal columns. It concerns a comparison with 2 elements (this year and last year). Do you also have a trick to do this?
Kindest regards,
|
|
|
|
|
|
Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 497
|
Hi Brenda,
You might get away with this:
Background color agent. Condition: allcount(all(c), d1, m1) > 0
Will work only if you have one comparison and one dimension on the horizontal axis.
BR / Ole |
Ole Dyring |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 9/19/2014(UTC)
Posts: 4
|
Hi Ole,
It doesn't work because it are multidimensional subtotals.
Kindest regards
|
|
|
|
|
|
Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 497
|
Hi Brenda,
The syntax will be specific according to the structure of your crosstab. So in order to make this work, I will need to see a screenshot of your crosstab.
BR / Ole |
Ole Dyring |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 9/19/2014(UTC)
Posts: 4
|
Hi Ole,
I've send you an email by Outlook to be able to attach a printscreen of my crosstab.
Brenda
|
|
|
|
|
|
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.