1. Open SigmaXL Demo Data.  Click the Customer Data Tab.
   
2.  Click SigmaXL > EZ-Pivot
   

3.  Ensure that entire data table is selected.  If not, check “Use Entire Data   Table”.  Click Next.
   

4. Select  Major-Complaint, click Count Category (X1)>>, select Customer Type, click Group Category (X2) >>  as shown:



 

5. Click OK.  Resulting Pivot Table:
   
   

Click HERE to download a Free 30-Day Trial.

Back to FAQ