Excel 2013 Pivot Table category is not correct.

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

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,639 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
    2020-09-30T09:17:26.507+00:00

    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.

    0 comments