multi level groups

  1. D

    Multi Level Pivot Table Average vs. Sum

    I have a scoring table for work group of work items completed. Based on that they have two set of scores that are combined for a weighted score. The Pivot table Rows are set up with manager first, then associate. The scores for the associate are calculated by Calculated Field based on several...
  2. M

    Hierarchy Chart for a 1 x 2 matrix direct sell company possible in Excel?

    I am brand new to the forum and am no expert at excel. I have a MAC Excel 2011 program to work with. I have created a direct selling model that pays commissions based on percentages of sales. I also have partner companies I am working with plus the product distributor. The partner companies (2)...
  3. A

    Multi level grouping in pivot tables

    I've been working with this this for about 4 days so I thought I would share now that I solved it: I got a pivottable (I construct from VBA) Then I want to list data either in rows or groups of groups of groups (metagroups). (in this case row would be a "verification/sale id", a group would be...

Watch MrExcel Video

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