Just do one while loading data itself ignore the negative values in script
LOAD * INLINE [
Sub Type, sales_Amount
one time, 39000
Resident Temp where sales_Amount>=0;
DROP Table Temp;
and finally your front end expression will be like this
=sum(sales_Amount)/sum(TOTAL sales_Amount) and make into percentage in number tab
Hope this will help you in neglecting negative values for subscription types..
just add a calculated dimension instead of adding "Subscription Type" as:
=if([Sales Amount]>=0,[Subscription Type])
and check "Suppress when value is null" for the same dimension you have just added
Now check.. it works..
Thanks and regards,