How can I insert calculated rows in Power Pivot?

Mich1202 1 Reputation point
2021-09-24T14:34:48.627+00:00

Hi All,

I am trying to add a calculation of gross profit in my power pivot table but instead of showing it via columns, I would want it to reflect on the row below my cost of sales. Please see below picture for reference.

135085-image.png

Thank you so much in advance for your help.

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,645 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pelle Bergkvist 76 Reputation points
    2021-11-17T17:58:33.457+00:00

    @Mich1202
    How does your data source look like?
    Is it possible for you to make changes to the underlying data source?

    0 comments