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
Show Totals in a Pivot Report?
CS Reports & Dashboards
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Hi@andorfuhrer
Thanks for posting this. We will evaluate the technical possibility for this before we pick this up.
Was just going to post the same question! Thanks GS Community
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?
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.
Perfect. That’s a good ida on the stack bar chart. It will definitely make things look better.
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
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!
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.
Is this on the roadmap to resolve?