Excel: Multiple filter columns in pivot table
<p>I have a spreadsheet that contains a large amount of data concerning error codes of products. The spreadsheet has columns for three error codes to be entered. </p>

<p>For example:</p>

<pre><code>errorcode1  errorcode2 errorcode3
88          
100         88
101
88          115        
110         90         88
</code></pre>

<p>The way the pivot table is set up, I can only filter by one error code. If I wanted to know the total 88 codes I would filter for 88 in errorcode1 which would only have a result of 2 even though there's two more. </p>

<p>Ideally the goal is to be able to add the results of the filters. For example</p>

<pre><code>errorcode1  errorcode2  errorcode3
88
100         88
88          115
110         90          88
</code></pre>

<p>How can I accomplish a running total of the error codes instead of being limited to one column?</p>