tailieunhanh - Pro SQL Server 2008 Analysis Services- P9

Tham khảo tài liệu 'pro sql server 2008 analysis services- p9', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 14 USER INTERFACES Row Labels Product Cate. Sales Reasons Figure 14-12. Nesting hierarchies 4 Row Labels 5 Accessories 6 Marketing 7 Other 8 t Promotion 9 Bikes 10 Other 11 Promotion 12 a Clothing 13 Marketing 14 Other 15 Promotion Pivot Table Ribbons The easiest way to work with a pivot table is with the PivotTable Tools ribbons which appear when you click inside the pivot table. There are two ribbons one for general options and one for design as shown in Figures 14-13 and 14-14. The ribbons are fairly self-explanatory but I strongly recommend browsing through them as you start working with pivot tables as it can be easy to forget they re there and get frustrated trying to work with the pivot table itself. For example selecting a pivot table to move it in a workbook is nontrivial but straightforward with the Move PivotTable button on the Options ribbon. Figure 14-13. The pivot table options ribbon The most notable function on the Options tab is the ability to rename the pivot table. If you work with Excel named ranges a lot you may find yourself a bit baffled as to how to name the pivot table by selecting a range on the worksheet. The easy answer is to just click inside the table and rename it on the Options tab. You can also select fields column and row headers value fields and work with their settings and expand or collapse them. With the Group Selection and Ungroup buttons you can select members from a hierarchy and create a custom grouping. For example if you have all 50 states listed you may want to group them into geographic regions. To do so just select the states you want to group together and click the Group Selection button. Repeat to create additional groups as you go any ungrouped members will be swept into a group called Other. 381 CHAPTER 14 USER INTERFACES Figur e 14-14. The pivot table design ribbon The pivot table design ribbon is pretty descriptive it provides the tools to change the appearance and layout of your pivot table. The .

TỪ KHÓA LIÊN QUAN
crossorigin="anonymous">
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.