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.
Create day in script and use third dimension as Day. It deserve !!
Show me where you done?
I can't reload because your data source is excel.