Excel Power Pivot: Reporting Packages to include different companies

[HenrikSLarsen]

Hi

I would like to create some reporting packages that include different companies, but I cannot get it to work.

In my example, I have:

• A sales table with two columns: CompanyName and SalesAmount
• A Company List: Company A, Company B, Company C and Company D
• A Reporting Package List: Package 1, Package 2 and Package 3
• A Mapping Table that sates that
  • Package 1 includes Company A and Company B
  • Package 2 includes Company B, Company C and Company D
  • Package 3 includes Company C and Company D

I would like a slices with the Reporting Package List that shows the three Reporting Packages and if I select “Package 2” then my sales table will only include Company B, Company C and Company D.

I have linked to an example file with data. The real examples have a lot more companies and reporting packages.

Link to exmaple file: ReportPackage - Pivot Problem.xlsx

Pictures

Yours sincerely
Henrik