Dynamic calculation

[mimz]

Hi,

I am new to Alteryx and I am hoping to get some help with a formula. I have a couple million of rows and I am trying to get the total sales of transaction which are shown in multiple fields for every item that was purchased. 

* I just need the total transaction value for all purchased items instead.

Please see sample image

[JohnJPS]

Hi @mimz 

You could transpose to a single column and then sum everything.

See attached workflow as an example.

Hope that helps!

John

[mimz]

Hi @JohnJPS

Thank you for the quick response. I was hoping to get the TS total for only distinct transaction id's and not repeated. so the 1692.8 answer would be incorrect and the right answer should be 669.86 for all transaction sales with distinct id's.

Thanks,

mimz

[JohnJPS · Accepted solution]

I see. For that, you could run it through the Unique tool, selecting only your column of interest, and then the Summarize tool to sum that column.

[mimz]

Thanks for your help @JohnJPS !