Subtract two rows from each other and build new row as a result

[MaxSchG]

Dear Community, 

I would like to substract two data series (over time below each other) from each other. After that would like to have the result as new column. Is that possible? 

Attached is the workflow.

Thank you,

Max

[vizAlter]

Hi @MaxSchG — Can you attach sample file for input, and desired output file, both as well?

[Maskell_Rascal]

Hi @MaxSchG 

So I'm thinking something like the below would work. You'd need to use a combination of Transpose and Crosstab tools. I've attached a sample workflow for you to use. Please note that this is only built to work with two rows in a data source. If you have several rows you'd like to do this to, then there are some additional steps that would need to be taken to get it to work. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[MaxSchG]

Thank you so much for your quick response! 

It looks very similar to what I want to accomplish. Please take a look at my drawing cause it shows you what kind of ouput I would like to have: 

I also attached my input (see in picture under current) so you can try to work on it with the actual dataset. 

Feel free to ask more questions. 

Max

[Maskell_Rascal]

Hey @MaxSchG 

If I'm reading your drawing correctly, you only want the two rows subtracted but flipped to columns and summarized by Month/Year. If that's the case, we can pull the data out at a different point in the workflow I sent you and add a couple more tools to get the results. Looks like this, and I've attached an updated workflow. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[MaxSchG]

@Maskell_Rascal 

Hey, thank you so much, thats almost the perfect output. The only adaption of the workflow would be to not seperate the months and year, just leave the date as it is. That would be perfect! Could you do that?

Thank you so much!

[Maskell_Rascal]

@MaxSchG 

Are you looking for it by Month or by the actual date?

Thanks!

Phil

[MaxSchG]

@Maskell_Rascal 

by Year-Month-Day, just like you found it in the raw data set that I uploaded for you 🙂 

Thanks,

Max

[Maskell_Rascal · Accepted solution]

@MaxSchG 

Got it! That makes it easier. See attached workflow. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[MaxSchG]

You made my day - what a pro! 

Thanks, 

Max