pivot report

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...

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...

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.....

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...

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...