Question

Show Totals in a Pivot Report?


Userlevel 5
Badge

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

 


7 replies

Userlevel 7

Hi @andorfuhrer 

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

Userlevel 2

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

Userlevel 7
Badge +2

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?

Userlevel 2

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.

Userlevel 7
Badge +2

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

Userlevel 5
Badge

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!

Reply