Adding holidays to a pivot table report

[Kamesh63]

Hi,

I have a PivotTable report consisting values generated from data that have series of dates (working days) of every month of a calendar year. These appear as column headings in my PivotTable report for which sumvalues appear in the report.


However, my problem is I need to show Sundays/holidays in the report, which though have 0 sumvalue. My original data for pivot table does not consist these Sunday/holiday dates. Is there anyway to do this automatically.


For example I have data for say January 2nd to January 9th excluding Sunday (January 8th). I want this excluded date appear in my PivotTable report with a 0 value. One way to do this go ahead and add this Sunday date to my data. But doing this for all Sundays and holidays in a calendar year(s) of data is cumbersome. I would like to know if we can add this automatically in my PivotTable report.


Thanks for your solution.

 

[prasaddn]

Hi Kamesh,


Interesting Question, and my immediate thoughts were same as you suggested adding dummy rows of data for Sundays.


To best of my knowledge, there is no automatically getting this added to pivot table. As the PT displays reports/formats based on what is availble in raw data.


Having said that, I did find a solution to display "Sunday", in PT with 0, if you are grouping the report by day of the week, i.e. Mondays, Tuesdays... etc., not by exact date/missing date.


Regards,

Prasad DN