Skip to main content
Open

Show Totals in a Pivot Report?

Related products:CS Reports
  • May 13, 2020
  • 12 replies
  • 266 views

andorfuhrer
Forum|alt.badge.img+1

Hi GS Fam!

I created a pivot report by CQ.  Is there a way I can populate the total for all 4 CQ?   In the example below, I would love the total to either be the first or last column

Also, I am doing this via GS SFDC, not NXT

 

12 replies

rakesh
Forum|alt.badge.img+2
  • Lets put your data to work!
  • June 23, 2020

Hi @andorfuhrer 

Thanks for posting this. We will evaluate the technical possibility for this before we pick this up. 


werickson
  • Helper ⭐️⭐️
  • July 9, 2020

Was just going to post the same question!  Thanks GS Community


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • July 9, 2020

You could put it in a dashboard and include a second report with just the totals. Are you planning to share this report in a dashboard?


werickson
  • Helper ⭐️⭐️
  • July 9, 2020

Thanks Jean!  I did try that.  It looks a bit ugly because the the size limitation enforcement on the dashboard.

I ended up using a stacked bar chart that allows me to put the data point values in, which is probably a better visual anyways.


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • July 10, 2020

Perfect. That’s a good ida on the stack bar chart. It will definitely make things look better. 


narayanan_s
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • November 18, 2021

Can we get this feature at report level instead workaround using dashboard. There is a use case where in weekly trend, there is a ask to send leadership on the count and total spread across customers success plans, activities and CTAs etc. NXT horizon analytics does miss this show total flexibility, may be i couldn’t find, hope we could add if unavailable. @rakesh 


  • Contributor ⭐️
  • January 13, 2022

I’d love if this could operate just like narayan said. Typically pivot tables have a column row and a sum column on it and it is pretty crazy to me that there is no option to do that!


Forum|alt.badge.img
  • Contributor ⭐️⭐️
  • July 7, 2023

@rakesh Can this be switched to an Idea for folks to upvote? I couldn’t find an existing Idea and this would be very helpful. If there is one, apologies as my searching only brought up this discussion.

 

We use lots of Pivot tables for assignments of our technical resources and to track Success Plan statuses. A column and row total would make things more succinct and easy to read vs. requiring someone to export the data or add yet another report to our dashboards. We have 1 dashboard with 7 pivot tables - this is not feasible to add 7 additional reports OR to export the data to get what we need. 


bradley
Forum|alt.badge.img+8
  • Expert ⭐️
  • July 31, 2023

@anirbandutta can this get converted?


anirbandutta
Forum|alt.badge.img+2
  • Expert ⭐️
  • August 1, 2023
No StatusAcknowledged

Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • September 5, 2024

Is this on the roadmap to resolve? 


Ravindrach
Forum|alt.badge.img+3
  • Contributor ⭐️⭐️⭐️
  • October 29, 2025

Hi Team,

Do we have any update on this request?