suppress rows in pivot table based on 2 dimension

[becki_kain]

I need to suppress rows in these pivot charts where either VEH_TYPE='Unk' or Segment='Unk'. these entries are getting counted in the variable  total_sales_vol_tp1=sum({1<[TP]={$(TP1)}>} TOTAL Volume) and that's the only place i need them counted.  I can't leave the rows out, when i pull the data in from sql->alteryx->qlik because i need the unknowns counted in the total and the user is picking the time periods, in qlik.  I searched here and tried things like:

=aggr(only({<Segment-={'Unk'}>} Segment),Segment)

=If(not Match(VEH_TYPE, 'Unk'), VEH_TYPE)

but those don't work because i need the OR between the dimensions- where VEH_TYPE or Segment = 'Unk', do not show.  Help, please?  and I've included a sample of the workflow.

thanks

becki kain

[sunny_talwar · Accepted solution]

Check attached....

[becki_kain]

wow, perfect. I was making this WAY harder than it had to be!