Forum Discussion

acamar22's avatar
acamar22
Icon for Helper I rankHelper I
2 years ago

Matrix - How to remove row subtotal on rows with more than 1 data point?

Hi everyone, thanks for clicking on my question!   I'm looking to remove row subtotals on rows that have multiple data entries as shown below: I would like for them to appear ONLY when the "Part #...
Need Help
acamar22's avatar
acamar22
Icon for Helper I rankHelper I
2 years ago

Hey BA_Pete thanks for your help.

 

I apologize, I didn't correctly demonstrate the data with the examples i provided.

 

The problem is that there are some rows with multiple [Animal Names], so it doesn't truly only have 1 value.

 

Any ideas on how to work around this?

 

 

I would still like it to display where it's circled.

 

Thanks again!

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
2 years ago

 

Ah, I see.

Then I think you were correct initially: You'll probably get what you need using ISINSCOPE([Animal Names]). Put an IF or SWITCH around it to ensure you get blanks when it's not in scope.

 

Pete