Simpatie.ro - matrimoniale
Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Nou pe simpatie:
Anna281 pe Simpatie
Femeie
24 ani
Iasi
cauta Barbat
26 - 45 ani
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] PIVOT Table - group dates, numbers, text

Pagini: 1 Moderat de TRaP, TonyTzu
#1
TonyTzu
Moderator
Postari: 252
Source:
http://www.contextures.com/xlPivot07.html

Grouping Text Items

The Grouping dialog box isn't available if you try to group items in a text field. Instead, you can manually group the items.

1. Select the items that you want to group
2. Right-click on one of the selected items, and click Group
This creates a new field in the field list, with the original field name and a number, such as City2
The new field is positioned above the original field in the pivot table layout, and the grouped items have a generic name, such as Group1.
3. To rename the group, select it and click F2, then type the new name.


 
   
Pagini: 1  
Mergi la