Hi to all user,

I'm new to this forum but I really need your help in my problem.

I'm creating a dashboard and I have a pivot table that I need to exclude the blank automatically.
But this pivot table was connected to slicer and if I select all values in the slicer, all data including blanks were calculated thus returning to error.

Can you help me? Your answer is appreciated.

Thank you!