Visual Cues in a Pivot Table

[darrellbutler]

Hi, I have a pivot table that has two dimensions Company & Month.

Company is  a vertical dimension and Month horizontal, the data field is a dividend paid by each company.                                                                               I want to compare dividends month on month by company. If May is greater than April this should be green, if it's less Red.                                                   I've tried entering a simple stament in visual cues =before([PPL},1,0) but this doesn't appear to work. Any help greatly appreciated.Darrell

[matt_crowther]

Darrell,

Makings of a solution attached.

If you need to remove the colour from the Total column just let me know.

(You can also use the 'Scramble' feature to hide sensitive data in the future)

Hope that helps,

Matt - Visual Analytics Ltd

[matt_crowther · Accepted solution]

Darrell,

Improved version attached.

All the best,

Matt - Visual Analytics Ltd

[darrellbutler]

Brilliant ! Cheers Matt this will do the trick ! Darrell