pivet table

  1. J

    Pivot Table Columns

    Hi There, Im struggling to find any literture on how to execute the below: I have a large data set that has all the information I need. These include: - Sales person - Job Status - Sales Price - Purchase Price - Profit as a $ - Margin as a % In the past, i have only needed to report on the...
  2. A

    Best approach to creating a formula(?) to loop through monthly data, if all employees have different start dates

    Hello, I'm currently working on a project with employee data and need to create a table that displays each employee's score for 5 different KPIs during each month of their employment. I have a huge table with all the relevant data and was trying to create a pivot table or write a formula that...
  3. 1

    Can you use a filter in an IF()

    Can you use a selection in a filter for a pivot table ie ALL and use an if() to do a calculation depending on filter value?

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