Generating a calculated row

[Guilherme91]

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:

Thank you,

Guilherme

[Jonathan-Sherman · Accepted solution]

Hi @Guilherme91,

It sounds like your looking to achieve the below?

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 · Accepted solution]

Hi @Guilherme91 

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

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

  

Dan

[benakesh · Accepted solution]

Hi @Guilherme91 ,

Another option .

[Guilherme91]

Solved.

Thank you!