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

Generating a calculated row

Guilherme91
6 - Meteoroid

Hi,

 

This must be a very simple exercise but I’m new to Alteryx and not able to do it.

 

I'm looking to create a additional row (C) in Alteryx by dividing row A by B:

 

Guilherme91_0-1573216722617.png

 

Thank you,

Guilherme

4 REPLIES 4
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Guilherme91,

 

It sounds like your looking to achieve the below?

 

image.png

 

If this solves your issue please mark it as correct, if not let me know! I've attached my solution for you to download if needed.

 

Regards,

Jonathan

danilang
19 - Altair
19 - Altair

Hi @Guilherme91 

 

Since you've got years as headers and these probably change over time, you'll need to use a transpose/crosstab approach

 

w.png

 

First transpose your data using F1 as the key.  Sort to get A followed by B for each year.  Use a Multirow to calculate your result.  Add  "Result" to use as the row header.  Cross tab and union with your original data

 

r.png  

Dan

benakesh
12 - Quasar

Hi @Guilherme91 ,

Another option .

benakesh_0-1573218831989.png

 

Guilherme91
6 - Meteoroid

Solved.

 

Thank you!

Labels