Fill a column with color to a pivot table

[Anonymous]

Hello,

I've got a pivot table:

Store	Mon	Tue	Wed
Store 1	1	-	-
Store 2	-	1	-
Store 3	-	-	1

And the data is:

Store	Day	Flag	Reason
Store 1	Mon	1	-
Store 2	Tue	1	-
Store 3	Wed	1	-
-	Wed	1	Sick

Question:

I need to fill by color (set a background to a column) where there are "reasons" in my pivot table. It's a column called "Wed".

How can I do it? Is it possible to fill a full (including empty cells) column ? Or just empty cells?

[Anil_Babu_Samineni]

Expected result?

[Anonymous]

all "empty" cells in the column "Wed" will be red (background color)  It would be nice

P.s. don't make changes in load script (preferably)

[Anil_Babu_Samineni]

Will you able to share sample QVW to check? I think i understand your question

[Anonymous]

I've prepared a sample based on this described example. (I don't have anything else)

I expected expressions/ideas (please don't attache any documents) I would be happy of any ideas.

[Anil_Babu_Samineni]

Perhaps this?

If(Day='Wed' and IsNull(Flag), Red())

[Anonymous]

Of course it's the easiest way to use : Day='Wed' but It could be any day

I need to fill by color (set a background to a column) where there are "reasons".

Please focus on "reason" data field.

[jaibau1993 · Accepted solution]

Go to chart properties -> Expressions

Open the design options of expression flag (i mean, click the '+' symbol next to the expression) and type in the background option the folloging:

=If(Sum(TOTAL <Day> if(Reason <> '-', 1)), red(), White())

It works form me. Hope it helps!

Jaime

[jaibau1993]

Note that i had to use

Reason <> '-'

because you filled null reasons as '-'. In case it is a true null value you should use

not IsNull(Reason)

By the way, I attach my solved .qvw

Jaime

[Anonymous]

It looks great! I will play around with it and hope I'll get the expecting result.

Thanks, Jaime.