question

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.

135085-image.png



Thank you so much in advance for your help.

office-excel-itpro
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.

@Mich1202-0154
Does the gross profit mean Income of each month minus Cost of Sales of each month?

0 Votes 0 ·

0 Answers