Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Total for Column for days by category

lumjingbki
8 - Asteroid

Hi Can you please help in achiving the below input to output. I have tried using cross tab and summarize tool but not able to achieve the below output. Attaching the sample data

 

Input     Output    
CategoriesCodeCountAmountDate CategoriesCodeAmount/Count2024010920240110
FurnitureMIA3010020240109 FurnitureMIAAmount100200
FurnitureMIA1520020240110 FurnitureMIACount3015
FurnitureLLB530020240109 FurnitureLLBAmount300200
FurnitureLLB1020020240110 FurnitureLLBCount510
      FurnitureTotal of AmountAmount400400
      FurnitureTotal of CountCount3525
2 REPLIES 2
Amit_G_Limbasia
9 - Comet

Dear @lumjingbki 

 

Please Find Attached workflow for your required solution

Solution Updated..

 

lumjingbki
8 - Asteroid

@Amit_G_Limbasia  Thank you for the solution 

Labels
Top Solution Authors