I am trying to recreate a pivot table in Alteryx where I can group by multiple fields as well as sort by different parameters in each of those fields (i.e. A-Z, ascending, descending, etc).
As seen within the desired output screenshot, I am grouping the data first by Sale Month (A-Z), then Sales Rep (Descending Sales Price), and lastly by product (Descending Sales Price).
The values I am calculating are the Count of the Products and the Sum of the Sales Price.
Within Alteryx, I understand the Summarize tool fairly well but am a little shaky on the Cross Tab and Transpose tools.
Desired Output:
Data:
