grouped

  1. D

    Creating a new Variable when changing how Pivot Tables are grouped

    My question: Where or how do I turn on the setting that will automatically create a new variable in the field list when I change how a pivot table is grouped in excel 2013? The problem: If I have multiple pivot tables from the same data source and I change how something is grouped then all...
  2. S

    Labelling Column and Row Groups

    Is it possible to label grouped row levels with a text label, rather than "1" , "2" etc ?
  3. N

    Form groups from list

    Dear MrExcel members, I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me. I want to make groups of x amount of products from a list. Example list: 1A34 2B43 1B544 5C45 3A52 5B32 Now I want Excel...
  4. M

    Group dates in 1 pivot without affecting another pivot based on same source data

    I have 2 pivot tables based on the same source data. I grouped the dates by months and year in 1 table and realised the second table was also getting grouped. How can I split the behaviour of the 2 tables?
  5. G

    Using calculated fields in Pivot Table data grouped by date

    Greetings, I have a Pivot table that has the following fields: creation_date sales_channel The creation_date is a date field as dd-mm-yyyy hh:mm:ss. I want create a pivot table that shows me the average sells made by a sales channel in a month. To do that, I grouped the creation_date by...
  6. A

    Excel 2003. Chart with grouped text values by X-Axis.

    Hello. I'm new in Excel2003. So maybe my question is very easy to resolve but I've looked a lot and have not still found the answer. So please help. The situation is the next: I need a simple chart for the next table: X-Axis values Y-Axis values a 122 b 117 c 112 d 114 a...

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
Back
Top