I have a pivot table with multiple report filters- I would like to make the filters additive so can drill down more efficiently- is this possible?
<table width="586" border="0" cellpadding="0" cellspacing="0"><col style="width: 154pt;" width="205"> <col style="width: 286pt;" width="381"> <tbody><tr style="height: 13.5pt;" height="18"> <td colspan="2" class="xl65" style="border-right: 1pt solid black; height: 13.5pt; width: 440pt;" width="586" height="18">Pivot Table Data Selection</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl67" style="height: 20.25pt;" height="27">Area</td> <td class="xl68" style="border-left: medium none;">USA</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Dept</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">MDSE Category</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Fineline Desc</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Product Category</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Custom</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Brand</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Item Desc</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> </tbody></table>
Thanks in advance-
<table width="586" border="0" cellpadding="0" cellspacing="0"><col style="width: 154pt;" width="205"> <col style="width: 286pt;" width="381"> <tbody><tr style="height: 13.5pt;" height="18"> <td colspan="2" class="xl65" style="border-right: 1pt solid black; height: 13.5pt; width: 440pt;" width="586" height="18">Pivot Table Data Selection</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl67" style="height: 20.25pt;" height="27">Area</td> <td class="xl68" style="border-left: medium none;">USA</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Dept</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">MDSE Category</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Fineline Desc</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Product Category</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Custom</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Brand</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> <tr style="height: 20.25pt;" height="27"> <td class="xl68" style="height: 20.25pt; border-top: medium none;" height="27">Item Desc</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">(All)</td> </tr> </tbody></table>
Thanks in advance-