Free Trial

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


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