How to sort a column contains both numbers and letters and Pivot

Question

Hi,

I am trying to sort a column with both numbers and letters (Column B below). I tried both data type "V_String" and "V_WString". Both not working. I have to use Excel to help me sort. How can I get it done in Alteryx?

After sorting,  I need to summarize column C (Sum_line item amount) per each change of column A (Document number) and Column B (Filing Jurisdiction). Currently the summary doesn't give me what I need. I guess it's because the sorting is not working .It will be greatly appreciated if someone can help. Thanks!

apathetichell · Answer

I'm sorry, but I'm not clear on what you want done with nulls and 00 - do you want them before state abbreviations? That's how alteryx sorts them... Do you need them filtered out of the datastream? Do you want a different value in there?

Kshen · Answer

Please see attached file below. Thanks

Kshen · Answer

Thanks for your response! Please see the attached file. This is what I currently have. I have summarized line item amount by grouping document and grouping state (means sum line item amount for each change of state and document number). The filing jurisdiction is still out of order. I will like the jurisdiction sort as descending. Thanks!

DZ JUNE 2021 pivotL.xlsx