...

• The Column labels entry specifies the column whose values make up the calculated columns of the pivot table. The calculation is performed across each of these values. In this case, each column contains calculations for separate store numbers.
• The Row labels entry specifies the column whose values define the grouping of the calculations. In this case, the sum of the sales column is performed for each product description value for each store.
• The Values entry specifies the aggregation function to compute for each cell in the new table. In this case, you are generating the sum of sales for each product description in each store.

• By default, this transformation generates a maximum of 50 new columns. However, if the column used for your Column labels contains more than 50 values, you may want to raise this value.

  Info
  NOTE: Avoid creating datasets that are wider than 2500 1000 columns. Very wide datasets can cause performance degradationPerformance can degrade significantly on even a much more narrow dataset. You should limit yourself to under 500 columns in your dataset.

  
  

Results:

...