Yog hais tias peb muaj ib lub rooj raws li tag nrho cov yuav tsum tau xam, ces nws plays ib tug tseem ceeb luag hauj lwm uas muaj nuj nqi lawv yog xam, vim hais tias. lub rooj tuaj yeem yog:
- Cov lim suav nrog
- Qee kab tau muab zais
- Muab cov kab sib sau ua ke
- Subtotals hauv ib lub rooj
- Qhov yuam kev hauv cov qauv
Qee cov txheej txheem hauv qab no yog rhiab rau cov xwm txheej no, qee qhov tsis yog. Qhov no yuav tsum tau coj mus rau hauv tus account thaum ua kev xam:
sum (SUM) – stupidly sums txhua yam nyob rau hauv lub xaiv ntau yam indiscriminately, piv txwv li thiab zais kab thiab. Yog tias muaj qhov yuam kev hauv tsawg kawg ib lub xovtooj, nws nres suav thiab tseem muab qhov yuam kev ntawm cov zis.
SUBTOTALS (SUBTOTALS) nrog code 9 hauv thawj qhov kev sib cav - suav tag nrho cov hlwb pom tom qab lim. Tsis quav ntsej lwm cov haujlwm zoo sib xws uas yuav xav txog cov subtotals sab hauv hauv qhov chaw.
SUBTOTALS (SUBTOTALS) nrog code 109 hauv thawj qhov kev sib cav - suav tag nrho cov hlwb pom tom qab lim thiab pab pawg (lossis nkaum) hlwb. Tsis quav ntsej lwm cov haujlwm zoo sib xws uas yuav xav txog cov subtotals sab hauv hauv qhov chaw.
Yog tias koj tsis xav tau cov lej, ces koj tuaj yeem siv lwm qhov tseem ceeb ntawm cov lej ntawm kev ua lej:
CHAV TSEV (AGGREGATE) - lub zog tshaj plaws uas tau tshwm sim hauv Chaw Ua Haujlwm 2010. Ib yam li SUBTOTALS, nws tuaj yeem tsis tsuas yog suav nrog, tab sis kuj suav qhov nruab nrab, tus lej, yam tsawg kawg nkaus, qhov siab tshaj plaws, thiab lwm yam - cov lej ua haujlwm tau muab los ntawm thawj qhov kev sib cav. Ntxiv rau, nws muaj ntau txoj kev xaiv rau suav, uas tuaj yeem teev tau raws li qhov kev sib cav thib ob:
- Xaiv cov kev suav rau ib lossis ntau qhov xwm txheej
- Muab tshuaj txhuam rau hauv kab lim
- Ceev nrooj zais thiab qhia cov kab thiab kab uas tsis xav tau