Set colours

[#1]

Hello everyone,

I'm trying to fix some colour due o the name of the field and i found out that i have a problem.

I've created a group with 3 drill-down possibles.

then i added the group in the dimension.

Lets says that,

Group have, name of customer, region, age.

Then in the backgroud colour, i've set up:

if ( Region='Lisbon', rgb (10, 120, 130), if (Region='Porto', rgb (10, 200, 40))

Its works perfectly for Lisbon and Porto.

My problem is when the Dimension of the Group is the first one or the thir one, customer or age, it gives one colour to all customers or ages.

Theres any solution without having to set up if (age=x, rgb () , if (customer=y , rgb ( ) ) ?

Theres any command that we could right if ( region = lisboa , rgb (10, 20, 30 ), All rgb possibles) ?

Best Regards,

Eliano

[stevedark]

Hi there,

I would recommend posting this into a new thread, as this one is marked as resolved and will not be looked at by people looking to provide solutions.

From the quick look I have had at the document I would say that you should use a cross tab on the data so all your responses are in a single column with another column that provides the detail of what question the answer relates to.

There are plenty of examples of the CrossTab statement in the manual and in the community.

Good luck with finding a solution.

Regards,
Steve