Then you certainly make use of these hierarchies to see just how hierarchies create organizing study easy inside PivotTables and you can, in a subsequent course, during the Power See.
Inside Fuel Pivot, change to Drawing Have a look at. Expand the newest Situations table in order to easier pick every one of its sphere.
Push and you may hold Ctrl, and click the activity, Discipline, and Knowledge areas. Having those individuals around three areas selected, right-simply click and pick Do Ladder. A dad steps node, Hierarchy step 1, is established towards the bottom of your table, together with chose articles are copied under the hierarchy while the boy nodes. Find out if Athletics looks first in the latest hierarchy, after that Punishment, after that Experience.
Double-click the label, Hierarchy1, and type SDE to rename your brand-new steps wing. You now have a hierarchy that includes Recreation, Discipline and Feel. Your Occurrences dining table now works out the next display screen. (más…)