Remove Null row in Pivot table but still show all columns

[#1]

Hi,

i've searched all the forum but still couldn't find any solutions for this. Attached is my example, I want to get rid of row 0 in the pivot table, but still showing all days columns. It has to be this option, Not using ValueList or add 5 expressions for each day, as I also need to have the action if i click on the cell in the pivot table, it'll do something.

[trdandamudi]

Sunny,

I did worked on this last night and I had the same issue where I am not able to see Column 1 day. So I was thinking I am missing something. I am also using Version 11.2. I used the below expression:

Expression:

If(Len(Trim(sum(Cases)))>0,Sum(Cases))

and checked  "Populate missing cells in presentation tab"

[sunny_talwar]

Did that work?

[trdandamudi]

It worked but missing column 1 day in the out put.