Always color bottom 50% of table in red according to current sort measure

[fzalexanderjohn]

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.

[timpoismans]

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.

[fzalexanderjohn]

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.

[pradosh_thakur]

try this
if (rowno()>=rowno(total)/2,red(),black())

[fzalexanderjohn]

Thank you, I still have the problem that sorting is disabled when I use the formula on a straight table.

[timpoismans]

I tested it in a straight table and could still sort it. Strange.

[fzalexanderjohn]

Strange indeed. I'm talking about the interactive sorting when you click on the row headers...

[timpoismans]

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.

[fzalexanderjohn]

Is any of that a measure? I used pretty much sum(sales) (and 3 others like it). So I have one dimension and 3 measures.

[timpoismans]

Yea, there's 3 measures in the table.