Excel 2013 Pivot Table category is not correct.

asked 2020-09-29T20:12:58.653+00:00
TDW 1 Reputation point

Excel 2013 pivot table shows a different name for a category than what is in the data table (data source it pulls from). i.e. "miscellaneous" shows as "win". There is no category "win" in the data source table. I've tried refreshing the data and re-adding the field.

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,333 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2020-09-30T09:17:26.507+00:00
    Emi Zhang-MSFT 10,516 Reputation points Microsoft Employee

    Hi,
    What kind of data source did you use? Excel file or other data source?
    Did you check if there are one more data fields in list?
    How did you create the PivotTable? Did you use Power Query?
    I suggest you copy the data source table to a new Workbook and create a new PivotTable.
    Try to provide more information or screenshots about this problem, I'm glad to help you.


    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.

    No comments