I want to have different colors in my pivot table background.
As you see in the sample, system does it well, when there are values in all cells. If there are no values, cells as well as dimensions do not have colors.
I defined background color with if(Division='A', lightblue(050), lightblue(100))
I did apped my sample .qvw
Who can help me with this?
Bernd
my testscript is very simple:
load * INLINE[ Company, Division, Month, Sales company 1, A, 01, 10 company 1, A, 02, 13 company 1, A, 03, 13 company 1, A, 04 ,17 company 1, A, 05, 12 company 1, A, 06, 21 company 1, B, 01, 10 company 1, B, 02, 16 company 1, B, 03, 17 company 1, B, 04 ,19 company 1, B, 05, 13 company 1, B, 06, 14 company 2, B, 02, 10 company 2, B, 03, 20 company 2, B, 05, 15 company 2, A, 02,10 ];
