Olap SSAS. Excel pivot table. Delete row if at least one column is empty

Question

Help please!

I have Olap Cube and measures in cube whom calculate in cube. In pivot table excel I see row when in column is empty, but not in all. I need to delete this row if some column is empty.
For example don't show this rows.

May by can write special macros or use Excel instruments?

Answer 1

By default a Pivottable will only hide rows where ALL the values are null/empty. So you could add and IIF to your response measure like IIF( ISEMPTY( measure1 ) and ISEMPTY( measure1 ) and ISEMPTY( measure3 ) , null , <existing logic for the reponse measure> ) this will return a null if all the 3 specified measures are empty otherwise it will calculate a result.

Answer 2

Thanks!
I thought that I can delete row "beautiful" without IF-ELSE