Pivot Table - selected column summaries

Help Center Get Answers
1

Hello!
Hope someone can help.
I want to put a total on just one specific column in a pivot table; it seems if you add column summaries it will sum EVERY numeric column - which in some cases is not relevant. EG, I have a pivot table of multiple currencies, with a face value sum, a payout calculation sum and an exchange rate average. Only the payout caculation needs to be totalled and if the others are, its completely irrelevant info (and confusing) info.

Here’s my table currently:

image
image600×622 48.5 KB

And here’s the table set up:

image
image571×553 10.3 KB

Oh - If I could also change the column headers that would be great!

I can do all this on a grid in Knack, I can do this on a pivot table in Excel, but cant figure it out on a pivot table in Knack!

Any advice please - maybe there’s a bit of code I can use?

Many thanks

LesleyB

2

Hi @Lesley - I’m not a coder but the below may help move you forward. I’m sure there is a more elegant method so hopefully others will jump in :sunglasses:


Pivot Table - selected column summaries - 3 mins

3

Oh that’s amazing, worked like a dream - thank you so much Carl! Much appreciated!

Happy Christmas :christmas_tree:
LesleyB
x

1 Like
4

Hey @Lesley - if you’re happy with the solution please mark this thread as “solved” :white_check_mark:

5

Yep - found the tick box now!

1 Like
6

Thank you, have a great Christmas and happy Knacking :rocket: