title: excel pivot table - query based on mulitple columns value
body: <p>I have a pivot table in excel that has an attribute say animals that holds 3 values (dogs, cats, birds)
  and the rows represent persons.</p>
  <pre><code>    |dogs|cats|birds|
  ----------------------
  John|    0|   1|    1|
  Jack|    1|   1|    1|
  Jim |    0|   0|    1|
  Pam |    1|   0|    1|
  Tess|    2|   1|    0|
  </code></pre>
  <p>I'd like to select all persons who have at least a dog and a cat, or exactly 2 dogs and a bird...
  I am trying to use calculated fields but I can't seem to be able to select the proper values</p>
  <pre><code>=IF(AND(animals['dogs']&gt;1, animals['cats'] &gt;1),&quot;YEAH&quot;, &quot;:-(&quot;)
  </code></pre>