How can I sort a pivot table sort by multiple columns?
<p>Hey stackoverflow community,</p>

<p>Looking to find a solution for a pretty simple problem (I think). In a normal Excel dataset, one can sort with many different options. If you go to <code>Data -&gt; Sort</code>, you can add multiple levels of sorting, i.e. "I want to sort by revenue, then total quantity, then alphabetic Product order, etc."</p>

<p>When in pivot table sorting, even if you only have one Row column (say Product), you cannot sort by multiple columns in values. So by product, I could not sort by Total Quantity descending, then Revenue descending.</p>

<p>The data needs to stay in pivot table format. Thanks all!</p>