Pivot Table

[maniram23]

HI Experts,

i have a pivot table. There i have three dimensions and one expression.

i need to show every day output (Include Missing Days). for that i was connected to master calendar.

After Connect to my master calendar i am receiving null values in a dimension calumn.

But I don't want to show the null values in a pivot table as a dimension level.

Please check for the reference i attached a file.

Regards

[srishsum2017 · Accepted solution]

Hi plz check this

[srishsum2017]

Actually 0 is not in dimension and it is subtotal....when i move it top or bottom subtotal it moves...so there is an only a alternative i know...if it is helpful for you so mark helpful other wise sorry