custom color for dimension in pivot table?

[Akina0929]

Hi all,

       I have created pivot table in the product category is there in product category I want different color to each product. but using custom color i am getting one color for all the dimension. how can i get different color for different product please help me.

Best regards

Anji

[Anil_Babu_Samineni]

May be write this for your dimension BG color

Color(FieldIndex('product category', [product category]))

[prat1507 · Accepted solution]

Hey

Please Use

Pick(Match([product category],'HPSD','Fabric Attach','Bura'),

rgb(255,0,0),

rgb(0,255,0),

rgb(0,0,255),

rgb(125,125,125))

in the Dimension Background color.

You can use as many dimensions as you like with the rgb codes of your choice.

Regards
Pratyush

[udeeshbl]

Correct Answer

[Akina0929]

Thank you pratyush  got it.