ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors