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.
解決済み

Need assistance with Total and sub total

vrajgopal
メテオール

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件の返信2
markcurry
クエーサー

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
メテオール

Thank you. Works perfectly fine

ラベル
トップのソリューション投稿者