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]

Hi

Please Check the attached qvw, i make some changs in dimension

[maniram23]

HI Sumit,

Thank you. for your replay.

You done good. But i need to show all days data. But your Output Second day data is missed.

Regards,

[farru_scorpio]

Hi Mani,

Please check suppress zero value.

[maniram23]

Hi Zubair,

We done same what you are suggested.

But I am getting null value in a dimension.

Regards

[Anil_Babu_Samineni]

Create day in script and use third dimension as Day. It deserve !!

[maniram23]

Hi Anil Babu,

It's not working. what you are suggested.

Regards

[Anil_Babu_Samineni]

Show me where you done?

[maniram23]

Hi Anil,

Please help Me.

[Anil_Babu_Samineni]

I can't reload because your data source is excel.