When there are a lot of columns in a pivot table, it is hard to track a row from left to right across the screen. Is there anyway to color code the rows, from left to right, across the screen and to have the color to alternate from row to row?
For example, the 1st, 3rd, 5th, ... rows would have white background color and 2nd, 4th, 6th.. rows would have blue color however the chart is expanded or collapsed.
I tried "if(even(RowNo()),'white','lightblue')".
This expression has 2 problems: 1. color only alternate on the lowest level; 2. empty rows are skipped within the column group. Therefore, color is not carried over from left to right and goes off sync.
I tried "if(even(RowNo(total)),'white','lightblue')". This is a bit better than the previous one because I'm starting to see more color alternation.
However, this expression still has 2 problems. 1. color of expanded rows do not alternate (items with sign); 2. empty rows are skipped within the column group. Therefore, color is not carried over from left to right and goes off sync.
I also tried to use "if(even(Dimensionality()),'lightblue','white')". This is a little closer to the expected results as I'm getting consistent color alternation with expandable items. But items of the lowest level still do not have color alternation.
So I tried to enhance it a bit. However, I'm hitting the same wall as the cells are not colored consistently due to lack of data and it doesn't look very good.