Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
From the table below, I am trying to achieve the following:
I want the first highest amount in the Amount column to change to a specific color both the background and the text to say red per customer selection that will be made. But, I don't know how to get that done. Please any help will be truly appreciated.
Year | Month | Invoice-type | Amount | # of invoices |
2015 | Jan | Advances | € 500 | 1 |
2015 | Feb | Advances | € 500 | 1 |
2015 | Mar | Advances | € 500 | 1 |
2015 | Apr | Advances | € 500 | 1 |
2015 | May | Advances | € 500 | 1 |
2015 | Jun | Advances | € 650 | 1 |
2015 | Jul | Advances | € 650 | 1 |
2015 | Aug | Advances | € 650 | 1 |
2015 | Sep | Advances | € 650 | 1 |
2015 | Oct | Advances | € 450 | 1 |
2015 | Nov | Advances | € 450 | 1 |
2015 | Dec | Advances | € 450 | 1 |
Thanks in advance,
Simon.
Go to "Visual Cues" tab, there you can configure rules to change color using a formula like
MAX( TOTAL Aggr(sum(Amount), Year, Month)))
Hey Clever,
Thanks for your reply but I have the amount as a dimension so based on the table I showed, can you help me with the expression I can use to change the colors. I am completely new to this.
Thanks
On the Dimension tab you should see a small plus sign to the left of each Used Dimension. Click the plus sign, click Text Color and add an expression, maybe something like :
if ( Month = 'Jun' , Red() , Green() )
Then change the expression to what suits your needs.
PFA