Skip to main content
New Idea

Include column summaries for pivoted reports

Related products:None

samantha_braastad
When creating a report with a pivot, it would be ideal to be able to get a sum, average, median of the entire columns as well.

7 replies

bhavani_murali
  • Contributor ⭐️⭐️⭐️
  • 10 replies
  • October 15, 2018
Hi Samantha,

Can you please share specific use case(s) where column totals are required with in a Pivot Report? 

Regards
Bhavani

samantha_braastad
Forum|alt.badge.img+1
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 229 replies
  • October 15, 2018
We are looking to understand our product usage by the type of User they are (Power User vs. Alert User) so we have pivoted the report on this field and listed out the data by account. In the summary, we would like to know the average # of users and logins across all accounts. See example report below: 



This example is broken out by account but we would like to do a similar action to break usage out by user for a specific account as well.

bhavani_murali
  • Contributor ⭐️⭐️⭐️
  • 10 replies
  • October 16, 2018
Thank You Samantha.  This helps.

Will discuss within the team to explore the efforts and possible timelines.  I will update this thread when we finalize the plan.

Thanks
Bhavani

  • Contributor ⭐️⭐️⭐️
  • 11 replies
  • January 15, 2019
Hi! I'd also love an update on this when available. Thanks so much!


heather_hansen
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 955 replies
  • August 10, 2020

I have a need for this as well.


Forum|alt.badge.img
  • Contributor ⭐️⭐️
  • 3 replies
  • July 10, 2023

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. 

 

Here’s one example where we Pivot on Success Plan Status and calculate the totals by CDL. It would be great to know how many each person has across all those status along with a total at the bottom by status. 

 


  • Contributor ⭐️⭐️⭐️
  • 13 replies
  • June 12, 2024

This would be extremely useful for my organization as well!


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