Skip to main content
Open

Show Totals in a Pivot Report?

Related products:CS Reports
jean.nairon
darkknight
andreammelde
bradley
+7
  • jean.nairon
    jean.nairon
  • darkknight
    darkknight
  • andreammelde
    andreammelde
  • tammy_c
  • bradley
    bradley
  • benwanlessmenlo
    benwanlessmenlo
  • sarahmiracle
    sarahmiracle
  • skessler
  • Joo Park
    Joo Park
  • ajharlow44
    ajharlow44
  • jennh
  • chae.stewart

andorfuhrer

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

 

11 replies

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

Hi @andorfuhrer 

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


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

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


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • 421 replies
  • 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 ⭐️⭐️
  • 14 replies
  • 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 ⭐️
  • 421 replies
  • 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 ⭐️⭐️⭐️⭐️⭐️
  • 61 replies
  • 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 ⭐️
  • 2 replies
  • 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 ⭐️⭐️
  • 3 replies
  • 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+7
  • Expert ⭐️
  • 1126 replies
  • July 31, 2023

@anirbandutta can this get converted?


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

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

Is this on the roadmap to resolve? 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings