pivot groups

  1. B

    Grouping data in pivot table - only in one pivot and not all of pivot of the sheet

    Dear all, Apologies if this is a basic question. I have several pivot tables based on the same data list. In some of the pivots I have dates in the "row area". I wanted to group by month in one pivot and by week in other pivot. The thing is when i choose to group by month, all the pivots in the...
  2. 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...

Some videos you may like

This Week's Hot Topics