Pivot Table - Dimension colour formatting

[#1]

I'm currently trying to colour a dimension on a pivot table as below.

Source	Month	Value
A	Oct	0
	Nov	2
	Dec	2

I want to have the source turn red when the value per source exceeds 3, however because the value is split by month the colour is not applying.

Thanks in advance.

CJ

[er_mohit]

try this in background color of Source.

aggr(if(Value>3,red())Value)

[whiteline]

Hi.

If you mean "value in any month of source exceeds 3", try this as a background color expression for Source dimension:

=if(Min(aggr(Value>3, Source, Month)), red(), null())

I assumed that you have two dimensions Source and Month.

[#4 · Accepted solution]

I was looking for the sum of source, not the individual months... with some looking up of the aggr function I have what I need

this gives me the amount per source

aggr(sum(Value),Source)

and the accompanying if statement

If(

aggr(sum(Value),Source)

>3,

rgb(200,10,10)

)

[whiteline]

In this case the "total" statement is useful to discard some dimensions:

If(sum(total<Source> Value) >3, rgb(200,10,10))

This will also work for Month dimension.

[#6]

Hi:

I want to color code my dimension field (and dimension only) based on the value of the dimension (not the value of the expression).

Is this possible?

Also, where can I find the background color expression for dimension? I can only find the background color expression for expressions.

Thank you very much.

Paco