Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Please Check the attached qvw, i make some changs in dimension
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,
Hi Mani,
Please check suppress zero value.
Hi Zubair,
We done same what you are suggested.
But I am getting null value in a dimension.
Regards
Create day in script and use third dimension as Day. It deserve !!
Hi Anil Babu,
It's not working. what you are suggested.
Regards
Show me where you done?
Hi Anil,
Please help Me.
I can't reload because your data source is excel.