Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Provide sample data.(data not in pics like above pls)
Hi Krishna:
I've attached a sample of the data to my post.
Thanks
Jeff
Hi Jeffry,
In Expression > Background Color write the IF condition.. like show in the image below
Venkata:
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)
Thanks
Jeff
Hi,
You have to write the IF condition on basis of expression. Not on basis of dimension.
Try with if condition for colour coding
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?
Jeff