Hiding dimension rows in pivot table

[#1]

Greetings from Gothenburg

I'm having a small problem and hope you guys can help!

I'm trying to get a pivot table to only show rows where a particular measure is not null. For example, in the Pivot Table below I just want rows 1 and 2 to show as they are the only ones having values on the "Company Top 60 %" column. I've tried to replace the "Company" column with a "Calculated dimension" such as

if(rangesum(Sum(Amount),above(Sum(Amount),1,rowno()))/sum(total Amount)<0.6, Company)

but this is giving me an expression error.

[#2]

Use for the other measures a check for the particular measure:

for example, Sales measure =if("Top 60%" <> 0, Sum(Sales))