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!

Alteryx Designer Desktop Discussions

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

Creating new rows based on categories

Macc365
5 - Atom

Hello I am new to Alteryx and am trying to create new rows for our states based on the following categories: NOL, NOL VA, All other DTA. My current output is only showing the categories with balance values, but I am trying to include all values for the categories like in my desired output below. Is there a way I can create a table similar to the desired output below? 

 

Current Output:

JurisdictionCategoryState Def Tax Rate - Prior PeriodState Def Tax Rate - CurrentEnding Balance At PriorRateEnding Balance At New RateTax Effected Change
ARAll Other DTA5.90%5.70%                                                   105                                                   110                                       5
IDAll Other DTA6.50%6.00%                                                   106                                                   111                                       5
IDNOL6.50%6.00%                                                   107                                                   112                                       5
NHAll Other DTA7.70%7.60%                                                   107                                                   112                                       5

 

Desired output:

JurisdictionCategoryState Def Tax Rate - Prior PeriodState Def Tax Rate - CurrentEnding Balance At PriorRateEnding Balance At New RateTax Effected Change
ARNOL5.90%5.70%$0.00$0.00$0.00
ARNOL VA5.90%5.70%$0.00$0.00$0.00
ARAll Other DTA5.90%5.70%$105.00$110.00$5.00
Total: AR   $105.00$110.00$5.00
       
IDNOL6.50%6.00%$107.00$112.00$5.00
IDNOL VA6.50%6.00%$0.00$0.00$0.00
IDAll Other DTA6.50%6.00%$106.00$111.00$5.00
Total: ID   $213.00$223.00$10.00
       
NHNOL7.70%7.60%$0.00$0.00$0.00
NHNOL VA7.70%7.60%$0.00$0.00$0.00
NHAll Other DTA7.70%7.60%$107.00$112.00$5.00
Total: NH   $107.00$112.00$5.00
       
Total: All   $425.00$445.00$20.00

 

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

@Macc365 
I managed to get the data tranformed as above but still missing the column total. has to go for a meeting now.

Maybe you can continue from there. 

😁

0524-Miguel_Chavez.PNG

SajeeshNS
6 - Meteoroid

I am a beginner but I gave a try. Hope, it might help you. 

 

SajeeshNS_1-1653384852326.png

 

Macc365
5 - Atom

Thanks this worked great!

Labels