Forum Discussion
Solved
display row based on two columns
Hi,
I have a table like shown below, I dont want to display rows when Regional Total Orders = 0 and Customer Total Orders > 0, but all other rows should be displayed. Could someone please help ? I tried the IF(AND(COND1, COND2), "True", "False) but I'm running into issues.
| Customer | Department | Region | Orders | Regional Total Orders | Customer Total Orders | |
| A Corp | Sales | Asia | 0 | 2 | 7 | Don’t Display this Row |
| A Corp | Marketing | Asia | 2 | 2 | 7 | Display this Row |
| A Corp | R&D | Europe | 5 | 5 | 7 | Display this Row |
| B Corp | Sales | Americas | 0 | 0 | 0 | Display this Row |
| B Corp | Procurement | Americas | 0 | 0 | 0 | Display this Row |
| B Corp | Research | Europe | 0 | 0 | 0 | Display this Row |
| C Corp | Sales | Americas | 0 | 0 | 24 | Don’t Display this Row |
| C Corp | Marketing | Americas | 0 | 0 | 24 | Don’t Display this Row |
| C Corp | HR | Asia | 10 | 24 | 24 | Display this Row |
| C Corp | Finance | Asia | 14 | 24 | 24 | Display this Row |
Why should your first row be excluded? Regional Total Orders for A Corp Sales Asia is not 0.
