excel pivot table pnl

ani d 1 Reputation point
2021-10-15T21:44:02.893+00:00

How could I add a column with percentage or relative values on the right ? Thanks in advance
140991-screenshot-pnl.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,489 questions
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,641 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viki Ji_MSFT 4,411 Reputation points
    2021-10-18T02:37:15.587+00:00

    Hi @ani d ,
    Welcome to Q&A forum!

    Please check if the following steps are helpful to you.

    • Click the PivotTable to select it, then click PivotTable Analyze>Fields, Items, &Sets>Calculated Field...>insert the fields you need and click OK.
    • Then go to the Value Field Settings >Show Value As to format the value. Please refer to my test:

    141126-test.gif

    Any updates, please let me know.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.