pivot report

  1. C

    Combining Multiple Tables in a Single Pivot Table

    I have a table for each month of the year on separate tabs each one named (both table and sheet) corresponding to the respective month The tables need to be on separate sheets for usability reasons. I want to create a pivot table which takes all 12 tables as input on one single sheet and allow...
  2. B

    Dealing with (multiple) many2many relationships in Powerpivot

    I have a question about how to deal with multiple many2many relationships in Powerpivot. Here is my scenario: I have a bunch of products, where each product is assigned to at least one but potentially more categories, so for example my first table is Product Category P1 C1 P1 C2...
  3. V

    Pivot Table - Creating customized restrictions for a Pivot.

    Every month I used to prepare a Pivot which consists data of different regions and my requirement is to restrict people to access others data if I'll send the same Pivot to every one.Please help me.....
  4. A

    show different information based on a password for a workbook

    How to show to sales people only individual reports based on a password to a workbook. The workbook contains a sheet with sales data for the company; by selecting a sales rep in a pivot table filter, it produces necessary reports. How to show to the sales manager all the reports, but to each...
  5. F

    excel 2007 - pivot table vs pivot report

    Hi All, I have been using excel2007 for few weeks now. Today I came across something "unusual". Before when creating a pivot table, I would get the following screenshot I could see"Drop data items here" as in excel 2003 Now I get something like that The funny thing is that with some...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top