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.
Solved! Go to Solution.
@PassION_es Can you upload the output based on your provided input file?
@binuacs Please refer to the output tab attached
Hi @binuacs
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
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?
@PassION_es you an use the below formula in the percentage formula
toNumber(toString([Count of Emp ID]/[Total count]*100,2,1))
thanks so much @binuacs