Pivot Table P&L

tlevine966

New Member
Joined
Dec 18, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi. I am building a Pivot table to be a P&L. I have raw data that I can't change as it is used by other tabs in the workbook. My raw data has positive numbers for Sales, rebates and expenses. When the pivot table sums it doesn't take into account that to get total Profit or Loss it would need to either show the sales and rebates as a negative and then add the expenses, or subtract the expenses from the sales. I have monthly data for many service areas and locations and want to slice on multiple levels. Is there a way to get the sales and rebates to become negative or another way to achieve my P&L?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,226,536
Messages
6,191,630
Members
453,668
Latest member
Stephen_Santos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top