Dynamic calculation

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

sample.PNG

Help

Dynamic Processing

Preparation

Data Investigation

Accepted answers

JohnJPS

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.

All comments

JohnJPS

Hi @mimz

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

See attached workflow as an example.

Hope that helps!

John

SumAllCols.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703