How to create a measure to calculate the sum of numbers in a column using a pivot table

ExcelPro Sometimes 1 Reputation point
2022-10-27T01:49:45.45+00:00

Hi, I'm using excel to create a pivot tables from a set of customer engagement data.

One of the columns list a number of participants. This column only has numbers in it. I would like to arrange this column by year, quarter, month, and date within a pivot table by the number of participants that were engaged.

However, when I use the SUM formula to create a measure within the pivot table, I get the following error message, "This formula is invalid or incomplete: 'Calculation error in measure 'Range 1'[Number of Participants in event]: The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String.'."

The error message is not making any sense.

Can someone help with figuring out an appropriate measure?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,669 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,031 Reputation points Microsoft Vendor
    2022-10-27T07:17:28.703+00:00

    Hi @ExcelPro Sometimes ,
    Based on the error message, I suggest you check the data format for the PivotTable. You can also provide the screenshots or sample data about the PivotTable here, so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments