not showing null item in filter
I'm not able add filtering to null item in excel. I have many items that any item includes fill or null data I want filter items to date and name to items that find out what item has data in month of year. but when I filter month and name of item in pivot table I can to show fill data only when I enable show item with no data in pivot option that show all null data of other item name, I want to show null data of item name selection no other item name, but I can't add filter to show null cell in pivot table pls guide me.
Try creating some sort of measure using mdx. Functions that might be useful when dealing with null are
Sounds like you might need to make use of this also:
Once you have some mdx written add it to your question.