display dates with no sales in the dimension

[ali_hijazi]

Hello

I got a pivot table

in the dimension I added Country, Brand, and Date

What I want to display is the following:

the user selects a year and a week of the year then I want to display all the days of the selected week and the one that has sales color the values in Greed and the days that don't have sales then color the background in red

Please advise

[#2]

Ali,

   For your need, you have to make a calendar table to have all the day even if there are no sales on it.

  Please find below a rapid example of what you can do.

Regards

Stephane

[rustyfishbones]

Add this expression to the Background color of the expression definition

IF(SUM(Sales) >=1, GREEN(), RGB(255,0,0))