Ask Your Question

average column of percentages - pivot table

asked 2016-05-06 17:53:09 +0100

Lonnie gravatar image

I am working with email data. There are columns with dollar amounts and percentages. I am attempting to average a column of percentages within a pivot table. Unfortunately, the cells in the pivot table are blank.

I can sum and count dollar amounts in the pivot table but when I try to average, sum, etc. the percentage column (open rate for emails), I get no result.

Am I missing something?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-07-12 16:47:51 +0100

It sounds like, when your data was imported, the % symbols may have been read as text. When this is the case, LibreOffice won't average them.

To fix this, I suggest a regex find-and-replace:

Find: (.*)% Replace: $1

(Make sure to enable Regular Expressions in the search box.)

This will give you numbers, which you can average, or convert to %, as need be. (If you convert them to %'s, LibreOffice will recognize them as such.)

edit flag offensive delete link more

answered 2016-05-06 18:01:38 +0100

Lonnie gravatar image

After working on this for half an hour I decided to post the question. After posting the question, I went back to the sheet are removed all formatting from the column (again), refreshed the pivot table and it works perfectly. It must have had something to do with formatting the column as a percentage in the original spreadsheet.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-06 17:53:09 +0100

Seen: 1,051 times

Last updated: Jul 12 '19