Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Office Sales 2018 Sales 2019
München | 400 | 500 |
Frankfurt | 300 | 10 |
Dresden | 200 | 50 |
Berlin | 100 | 200 |
Say I have the table above and I always want the bottom 50% of the table colored in orange. So when I sort by Sales 2019, the table should then look like this:
Office Sales 2018 Sales 2019
München | 400 | 500 |
Berlin | 100 | 200 |
Dresden | 200 | 50 |
Frankfurt | 300 | 10 |
I tried using RowNo() but then sorting is turned off automatically.
You should be able to use the following:
If(RowNo(total)>NoOfRows(total)/2,Red())
You can change the Red() to the colour you want.
This will colour the bottom half of the table in your desired colour. In case of an uneven amount of rows, it'll colour the largest part, e.g.: 5 rows, row 3 till 5 will get a colour.
Thanks, the coloring does work but as soon as I use it, the straight table is no longer sortable, which is the key part here.
Using the code from my first post, I can do the following:
Sorted by Project_ID:
Sorted by Project_final_status:
Sorted by Project_start (high to low):
No idea how it works for me, but won't for you.