How to stop (blank) appearing in a powerpivot 2013 Pivottable

[masplin]

When I product a pivot out of PP 2013 and arrange in tabular form I get (blank() in every cell where there is no data i.e. in the data model the field is blank. I tried the layout setting "fro empty fields show", but even if i put zzz nothing changes. I even changed the formula in PP to be sure the cell really is a blank. there must be a way to make this return a blank as look rubbish?

Thanks

Mike

 

[RedllowFenix]

I had this problem (When creating a pivot from power pivot, any blank cells are shown as (Blank) rather than just being empty or 0). After much playing around I found that in powerpivot, when you create the pivot table with the Pivot table button, create it as a "Flattened Pivot table". Seemed to work for me

Could you please elaborate? I have a pivot table with a row of only Measures. I'm trying to figure out how to filter out the blanks results, but I'm having trouble.