In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Subtotaling

John_Ballou
6 - Meteoroid

I need to create a work flow that mimics Excel.  I attached an example.

11 REPLIES 11
TheOC
15 - Aurora
15 - Aurora

hi @John_Ballou 

I would need what data you are inputting, to be able to create this.

Cheers,
TheOC

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
mathieuf
Alteryx
Alteryx

Here is a way to accomplish that.

John_Ballou
6 - Meteoroid

is there a way to incorporate the 3 buttons.  To get Grand Total, total by Employee, total by Employee with raw data for auditing?

mathieuf
Alteryx
Alteryx

I'm sorry, I don't understand.

Can you try to share the outcome you are looking for?

 

In my workflow, the totals are included with the details.

John_Ballou
6 - Meteoroid

Original attachment had the desired output, the input would be the file with out the subtotals.

John_Ballou
6 - Meteoroid

It would be the file I attached with out the subtotaling

mathieuf
Alteryx
Alteryx

My outcome is

 

mathieuf_0-1639151430986.png

 

You can add more steps to the process to remove the subtotal or even create multiple output from the same workflow.

binuacs
21 - Polaris

Very similar to @mathieuf  solution

binuacs_0-1639155921834.png

 

John_Ballou
6 - Meteoroid

the original files i attached had the data required!!!

 

Labels
Top Solution Authors