I want to create a table with the following Dimensions:
My Expression (data being displayed) is:
When I create a Straight Table I get basically a list:
A pivot table works ok, but not the look I want (I don't like WeekYear label):
Is there a simple way to create a Straight Table with the dimensions listed above that looks move like this mock up?
I'll get into asking about conditional colors later.
That part I know how to do. The condition I want to create is:
And this will carry on for all of the following weeks (current vs previous)
I understand the concept of conditional formatting background based on data expressions.
The hard part is dynamically comparing the cell data from column 1 to column 2; 2 to 3; 3 to 4, etc...
It's not just based on the data in cell by itself.
Am I making sense?