Need a special offer?Find out if your project fits.
+

add a 2nd column total

Answered
jaymer asked on June 17, 2024

using your sample pivot table,

you show grand totals at the bottom of the pivot.

As shown in the attachment, my customer needs an additional row for "% of Grand Total",

which you support, but I only want 1 new row of numbers at the bottom.

I cannot find out how to do this.

Thx

Attachments:
monster1.jpg

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster June 18, 2024

Hello, Jaymer!

Thank you for reaching out to us.

Kindly note that in Flexmonster, it is possible to add a new measure to calculate the percentages, as shown in the example: https://jsfiddle.net/flexmonster/dwhxL1n3/.

We can also suggest creating a second Flexmonster instance to show the Totals row as follows: https://jsfiddle.net/flexmonster/4L9n0ub1/.

Hope you will find our answer helpful.

Kind regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster July 2, 2024

Hello, Jaymer!

Hope you are doing well.

Our team is wondering if you had some time to check our previous response about adding a second measure to the totals row. Could you please let us know if you have any further questions?

Looking forward to hearing from you.

Kind regards,

Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster July 10, 2024

Hello, Jaymer!

Hope you are having a great week.

Just checking in to ask if our example of adding a second measure to the totals row was helpful.

Looking forward to hearing your feedback.

Kind regards,

Solomiia

Please login or Register to Submit Answer