To show full days of every month

[tan_chungkam]

Hi All,

Please find attached my excel table and qvf files.

I have a pivot table as screenshot shown.

I would like to show full days of every month.

For e.g. it should show 1/1/2018 ~ 31/1/2018 instead of just show 1/1/2018 - 10/1/2018.

My pivot table

My Scripting

[Channa]

include Null values under Tecnician

[jonathandienst]

Check the Include Zero Values option in Add-Ons | Data Handling and make sure that the calendar file has dates for January after the 10th.

[tan_chungkam]

Hi @jonathandienst ,

Thanks for the advice.

I already checked it but it still the same.

[tan_chungkam]

Hi @Channa ,

If i check that Null Value for Technician, there will be a '-' shown in the table.

It is not the outcome that i want for.

[Channa]

for that date there is no technican ..so it will show -

[tan_chungkam]

@Channa ,

Of course i know there is no technician on those dates.

That's not the outcome that i want.

What i want is it should the dates even there is no technicians at the same time i don't want see there is a null value as the above screenshot.

Just for your clear understanding below is the outcome that i want.

My expected outcome