Show al dates in Pivot table

[Anonymous]

Hi All,

I have the below pivot table which shows data for last 7 days.

Dimension : CDate

                     LOB

Expression I have used is =sum({<CDate = {">=$(=today() - 6 ) <$(=today() +1)"}>} Sales)

Cdate/LOB	Manual	Auto	Referred
10/19/2017	10	0	0
10/18/2017	10	35	0
10/17/2017	78	39
10/16/2017	67	6	6
10/14/2017	0	78	0
10/13/2017	89	0	8

In the above table we don't have any entry for data 10/15/2017 so that date is skipped. Is there any way to show that date irrespective of whether data is there?

When I clicked "Show all values" its not restricting to 7 days and shows all the dates.

Any help would be much appreciated.

Thanks,

Anupama Jagan

[its_anandrjs]

In your chart, if you select suppress when value null then removes and select show all values in all dimension and then check what result you get. Also, check first do you have any line items for this date in a row in your data model or if not exists you need a correct master calendar in the data model.

[Anonymous]

No line item is there for that particular date in our DB. so should I create a master calendar which generates last 7 days?

Will you be able to help with it?

Thanks,

Anupama Jagan

[matteo_mi]

You may can generate the missing date , look this thread

Filling in the missing data

[Anonymous]

In that the values are getting populated, whereas in mine the missing dates should have only 0. Is that possible?

[florentina_doga]

pls see attach