34
• sorts,whichcontroltheorderinwhichthedataappears
• ranking,whichenableyoutoviewtopandbottomvaluesofselecteddata.
• calculations
• breaks,whichbreakupblocksofdata.
• filters,whichenableyoutoviewonlythedatathatyouneed.
ThereisabuttonforeachfeatureintheSliceandDicePaneltoolbar:in
order,theyareSorts,Ranking,Calculations,Breaks,andFilters.
Noneoftheabovefunctionalitiesisspecifictosliceanddicemode;however,
theSliceandDicePanel'sgraphicalinterfaceprovidesauser-friendlyway
toapplythem.Moreover,itisusefultobeabletoperformsliceanddice
operations,thenapplyoneormoreofthesefeaturestothereport.For
example,ifyoubuildamaster/detailreportthatdisplaysrevenuebyresort,
youcanquicklycalculatethetotalrevenueperresort.
Inthesectionsthatfollow,youlearnhowtousetheSliceandDicePanelto
applysorts,ranking,calculations,breaksandfiltersonreportdata.
Referencestomoreinformationonthefeaturesareprovidedintheir
respectivesections.
Toapplyasortondatainthereport
1. SelectaniconintheSectionboxortheBlockStructurebox.
2. ClickApplySort.
Asorticonappearsnexttoorbelowtheiconyouselected.
3. Toinvertthesort,double-clickthesorticon.
4. Toremovethesort,selectthesorticon,thenpresstheDeletekey.
Forfurtherinformationonsortsandhowtoapplythemonreportdata,refer
totheDesktopIntelligenceUser'sGuide:ReportTechniquesandFormatting.
Toapplyrankingondatainthereport
1. SelectaniconintheSectionboxortheBlockStructurebox.
2. ClickApplyRanking.
Arankingiconappearsnexttoorbelowtheiconyouselected.
150
DesktopIntelligenceAccessandAnalysisGuide
SliceandDiceMode
9
Workinginslice-and-dicemode