Formatted table same as Pivot

Hello Alteryx Community,

Requesting assistance on how to replicate in Alteryx the formatting from the excel pivot created. I have here in the attached the dummy input and output for your reference. Please note that in reality my dataset has 30,000 line items and my pivot has 100 rows. Can these be possible in Alteryx table tool? Thanks.

dummy_pivot.xlsx

Datasets

Tips and Tricks

Transformation

Accepted answers

binu_acs

@PassION_es you an use the below formula in the percentage formula

toNumber(toString([Count of Emp ID]/[Total count]*100,2,1))

binu_acs

@PassION_es for the pivot tables you can use the analytical app setup

Pivot_27052024.yxzp

All comments

PassION_es

Hi, Please refer to the updated and correct output. Thank you

dummy_pivot.xlsx

binu_acs

@PassION_es Can you upload the output based on your provided input file?

PassION_es

@binu_acs Please refer to the output tab attached

dummy_pivot.xlsx

PassION_es

Hi @binu_acs

I already completed a workflow but without table formatting using the previously attached file as the input. As you can see in the Percentage column, the data type is in fixed decimal 19.14. How can i make it to be in the same pivot format without being truncated assuming there will be hundreds of rows in the output table? Thank you

Pivot_workflow.yxmd

PassION_es

Additional question, The excel file will contain 5-7 pivots in every tab. Will it be possible in Alteryx to have all of them a presentable format with colors in the header field and in the total row same as in pivot?

binu_acs

@PassION_es you an use the below formula in the percentage formula

toNumber(toString([Count of Emp ID]/[Total count]*100,2,1))

binu_acs

@PassION_es for the pivot tables you can use the analytical app setup

Pivot_27052024.yxzp

PassION_es

thanks so much @binu_acs

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703