Paunenge uchishanda nematafura mahombe epivot, kazhinji unofanirwa kuarerutsa nechisimba, uchisefa rumwe ruzivo kuti usanyura muhuwandu. Nzira iri nyore yekuita izvi ndeyekuisa mamwe minda munzvimbo yekusefa (mushanduro pamberi pa2007 yainzi nzvimbo yepeji) uye sarudza chete hunhu hunodiwa kubva pane anodonhedza pasi:
Kuipa kweiyi nzira kuri pachena:
- Kana zvinhu zvakawanda zvasarudzwa, hazvioneki, asi zvinyorwa "(zvinhu zvakawanda)" zvinoonekwa. Usambofa mushandisi ane hushamwari.
- Imwe report sefa yakaomeswa kune imwe pivot tafura. Kana isu tiine akati wandei matafura epivot (uye kazhinji nyaya yacho haina kuganhurirwa kune imwe chete), saka kune yega yega (!) Iwe uchafanirwa kugadzira yako wega sefa uye kune yega yega uchaivhura, tara zvinhu zvinodiwa uye tinya. OK. Zvinotyisa zvisingaite, ndakatoona vanofarira vakanyora yakakosha macros nekuda kwechinangwa ichi.
Kana iwe uine Excel 2010, saka zvese izvi zvinogona kuitwa zvakanyanya nenyasha - uchishandisa zvimedu (zvimedu). zvimedu ibhatani riri nyore graphical inomiririra yekudyidzana mushumo mafirita ePivotTable kana Chati:
Iyo slicer inoita seyakasiyana graphic chinhu (sechati kana pikicha), haina hukama nemaseru, uye inoratidzwa pamusoro pepepa, izvo zvinoita kuti zvive nyore kuifambisa. Kuti ugadzire slicer yetafura yepivot iripo, enda kune tab Parameters (Sarudzo) uye muboka Ronga uye sefa (Ronga uye sefa) tinya bhatani Namatidza Chikamu (Isa slicer):
Zvino, kana uchisarudza kana kusasarudza slicer zvinhu (unogona kushandisa makiyi Ctrl и kusuduruka, pamwe nekutsvaira nebhatani reruboshwe regonzo rakadzvanywa kuti usarudze muhuwandu) tafura yepivot icharatidza chete data yakasefa yezvinhu zvakasarudzwa. Imwe yakawedzera yakanaka nuance ndeyekuti chimedu chiri mumavara akasiyana chinoratidza kwete chakasarudzwa chete, asi zvakare chisina chinhu zvinhu izvo zvisina kana kukosha kumwe chete patafura yekubva:
Kana iwe ukashandisa akawanda slicer, izvi zvinokutendera iwe nekukurumidza uye nekuona kuratidza hukama pakati pe data data:
Iyo imwechete slicer inogona kubatanidzwa nyore nyore kune akawanda PivotTables uye PivotCharts uchishandisa iyo Parameters (Sarudzo) bhatani PivotTable Connections (Pivot table connections)iyo inovhura iyo inoenderana dialog box:
Ipapo kusarudzwa kwezvinhu pane imwe chidimbu kuchakanganisa akati wandei matafura uye madhayagiramu kamwechete, pamwe kunyangwe pamapepa akasiyana.
Chikamu chekugadzira hachina kukanganwa zvakare. Kugadzira zvicherwa pane tab Constructor (Dhizaini) Kune akati wandei inline masitaera:
... uye kugona kugadzira yako yega dhizaini sarudzo:
Uye mune "pivot tafura - pivot chati - chidimbu" musanganiswa, zvese izvi zvinotaridzika zvinoshamisa:
- Chii chinonzi pivot matafura uye magadzirirwo awo
- Kuisa nhamba nemazuva nedanho rinodiwa mumatafura epivot
- Kuvaka Chirevo chePivotTable pane Akawanda Ranges eMabviro Data
- Gadzira maverengero muPivotTables