Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Table sorting/formatting in Pivot option

Highlighted
Asteroid

Hi,

 

I am using following input:

YearMonthNumberMonthWeekCount
20181Jan5
20182Feb4
20183Mar1

 

I am getting following output from the attached workflow:

Year                  Feb    Jan            Mar
2018405010

 

But the desired output is:

Year                  Jan    Feb            Mar
201850%40%10%

 

Kindly assist. Thanks in advance.

Alteryx Partner

  Hi

  This approach may satisfy your requirements.

 

20190925_00001.png

Highlighted
Asteroid

@derekbelyea thanks for your reply. But I need to use Table tool for this and also I need to display final values with % symbol.

Labels