Alteryx Designer Desktop Discussions

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

Need assistance with Total and sub total

vrajgopal
7 - Meteor

I am trying to replicate the below Pivot is Alteryx.

 

Succeeded in getting the Pivot format but am not able to get the totals column as seen below in the pic. Need assistance in getting the totals as shown below.

 

Vrajgopal_0-1579243290735.png

Attaching the raw data and also my workflow.

2 REPLIES 2
markcurry
12 - Quasar

Here's a way of doing it without using the Reporting tools if that helps, just appending the Product/Services totals and the Grand totals

Subtotals.png

vrajgopal
7 - Meteor

Thank you. Works perfectly fine

Labels