Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Hope you are fine. I have a scenarion in which I want to have custom colors for different expression columns. Is there any way to do it? I want this in a Pivot table.Please let me know. Below is sample given.
Regards,
Sharma
Hi Sharma,
Let do this way:
1. Settings-> User preference -> Design -> Check "Always Show design menu item"
2. Right click on chart -> "Custome format cell"
See the sample attached file.
Do let me know if you are looking for this one.
Regards,
Sokkorn
Hi Sokkorn,
Thanks for your time and looking into this. But this way, the color for all the expression column will change if change color for any of expression column. In my scenario, I want to have different colors for different expression columns. As shown in my example, Exoression Column1 should be Yellow, Exoression Column2 should be Blue and Exoression Column3 should be Green. Is this doable ?
Thanks.
Sharma
Hi Sokkorn Cheav ,
Thanks for beautifull Explanation was looking for it
Good !!!
Warm regards,
Anant Dubey
Hi Sharma,
I'm not sure whether you check my attached sample file yet. By the way I think we can do it using my scenario.
Regards,
Sokkorn
Hi Sokkorn,
You can have different colors for dimenstion columns and expression columns and I agree with you. But my problem is little different here.
I have 5 dimenstion columns and 8 expression columns.I want different different colors for expression columns only( i.e different color for each 0f 8 expression column)a. I am not caring for dimension column's color and it can be anything. Please let me know if I am missing something here.
Regards,
Sharma
I'm looking to do the same thing but when rightclicking and selecting "Custom Format Cell" the dropbox "Apply change to" only gives the option "All dimensions"
Hi Sharma,
I would suggest you to make use of Expressions Background Color option to mention different colors expression column level wise.
Hope this resolves your color issue.
Thanks,
Kumar
The expression doesn't color the headers, only the fields below. In my case and in Sharmas case we want to change the color of the header only. Sharma has an image of excel in her post, that's what I would like it to look like too.
Cheers!
How do you manage to change only 1 header?
When I change 1 header, all headers are automaticaly changed.
I have "Apply change to", but I can't change it, it's always "All dimensions".
I tried with QV 10 SR 6 and QV 11 SR 2.