Cross Tabulation With Hierarchy Cross-tabs can be easily extended to deal with hierarchies Can drill down or roll up on a hierarchy category item-name dark pastel white total womenswear skirt 8 8 10 53 dress 20 20 5 35 subtotal 28 28 15 88 menswear pants 14 14 28 49 shirt 20 20 5 27 subtotal 34 34 33 76 total 62 62 48 164 Database System Concepts-5th Edition,Aug 26,2005 18.11 @Silberschatz,Korth and SudarshanDatabase System Concepts - 5 18.11 ©Silberschatz, Korth and Sudarshan th Edition, Aug 26, 2005 Cross Tabulation With Hierarchy Cross-tabs can be easily extended to deal with hierarchies Can drill down or roll up on a hierarchy