Mich1202-0154 avatar image
0 Votes"
Mich1202-0154 asked emilyhua-msft commented

How can I insert calculated rows in Power Pivot?

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.


Thank you so much in advance for your help.

image.png (4.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Does the gross profit mean Income of each month minus Cost of Sales of each month?

0 Votes 0 ·

0 Answers