Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Cross Tab - Aggregate Values Using Count on Text Fields

When using the Cross Tab tool, the Count option under Method for Aggregating Values only appears when the field selected for Values for New Columns is a numeric field. I can add a numeric RecordID before the Cross Tab and then count on that, but why can't the Cross Tab count non-numeric fields? The Summarize tool can.

4 Comments
Pang_Hee_Choy
12 - Quasar

Yes, we need this function.

 

it just count for non number field.

 

i have to create a number field to be sum in cross tab.

patrick_digan
17 - Castor
17 - Castor

This would be great and avoid having to use a workaround

8088
7 - Meteor

Agreed !  I'm actually surprised that this simple (yet valuable) enhancement has not gotten more traction in the past three years.  I'm certainly adding my voice to this one - counting text values in the crosstab is definitely a must !  With and without nulls, please.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes