• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Calculated Field for dates

Pablo

New Member
Hi all,

I have an inventory count list of few thousand items. The fields are: location, item number, description, quantity and date. In the same file I have data from June and July. By using a Calculated Field in a Pivot Table, how do I calculate the inventory change from June to July (the difference) and also see the June and July quantities?

Thanks for your help.

Pablo
 
Pablo


Can you paste a sample file ?

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hui,

Thanks for following up. Unfortunately I have no access to any of those sites (Internet access restrictions), but I pasted a small sample right below, you can copy and paste this in Excel.


ccenter itemid sc_debit_gl sc_credit_gl alt_descr total_value MTH

6153508 163226 610000 130150 SED-96277 CALCIUM 123.26 06/30/13

6153508 163228 610000 130150 SED-96278 CREATININE 215.71 06/30/13

6153508 163233 610000 130150 SED-96289 GOT/AST 161.78 06/30/13

6153508 163237 610000 130150 SED-6962 MAGNESIUM 269.64 06/30/13

6153508 163351 610000 130150 SED-96353 QUICKLYTE FLUSH SOLUTION 103.28 06/30/13

6153508 165881 610000 130150 RGT, RF12, INNOVIN GROUP A-EAST, 12X20ML, LOT539213, EXP 9/28/14 137.97 06/30/13

6153508 3027 610050 130000 CONTROL, 5C CELL TRIPACK, 9 X 3.3 ML/PK 167.80 06/30/13

6153508 29861 610050 130000 SED-CHEK ESR BILEVEL CONTROL(VESMATIC) 245.28 06/30/13

6153508 31483 610050 130000 CONTROL, IA/TDM QC, LEVEL I,II,III(W/ 932 & 933) 12x5ml 340.21 06/30/13

6153508 74543 610050 130000 DRUG CALIB,2X5ML/PK 147.92 06/30/13

6153508 163349 610050 130000 SED-96355 QUICKLYTE STANDARD A 103.28 06/30/13

6153508 163350 610050 130000 SED-96354 QUICKLYTE STANDARD B 103.28 06/30/13

6153508 18003 610000 130150 REAGENT, ABSORBANCE 114.50 07/31/13

6153508 18370 610000 130150 REAGENT, BUN 316.80 07/31/13

6153508 27080 610000 130150 COAGULATION SYSTEM WASH,EA 140.82 07/31/13

6153508 60871 610000 130150 DILUENT, SAMPLE 6 X 500 ML 117.60 07/31/13

6153508 67684 610000 130150 MULTISTIX 10 SG AMES 2161 BT/100 BT 130.08 07/31/13

6153508 74633 610000 130150 HCG DM RXL,120T/EA 720.00 07/31/13

6153508 74666 610000 130150 VANCOMYCIN,80T/EA 283.20 07/31/13

6153508 100404 610000 130150 VALPROIC ACID KIT 283.20 07/31/13

6153508 126963 610000 130150 ECO2, 360/TST CT 108.00 07/31/13

6153508 139964 610000 130150 REAGENT, TOTAL BILIRUBIN, 480TS 201.60 07/31/13

6153508 163216 610000 130150 SED-96281 ALBUMIN 115.20 07/31/13

6153522 128055 610050 130000 KOVATROL III NORMAL 10X60ML 303.35 06/30/13

6153522 134151 610050 130000 CALIBRATOR, DRUG II, 10 X 2 X 5 ML 147.40 06/30/13

6153522 163349 610050 130000 SED-96355 QUICKLYTE STANDARD A 206.55 06/30/13

6153522 163350 610050 130000 SED-96354 QUICKLYTE STANDARD B 206.55 06/30/13

6153522 42263 610200 130000 REACTION TUBE SYSTEM SU-40,PK 605.92 06/30/13

6153522 43274 610200 130000 KOVA TUBE ECONOMY,500/PK 121.74 06/30/13

6153522 31017 610300 130255 KOVA-GLASSTIC SLIDE 10 50 SLIDES/PK 127.63 06/30/13

6153522 18150 610000 130150 REAGENT, LYSES III DIFF, 5 LITER CUBE 206.17 07/31/13

6153522 18370 610000 130150 REAGENT, BUN 259.20 07/31/13

6153522 27080 610000 130150 COAGULATION SYSTEM WASH,EA 234.70 07/31/13

6153522 41546 610000 130150 STAIN, DIFF QUICK 3X16 OZ SOLUTION 138.87 07/31/13

6153522 60850 610000 130150 REAGENT, AMYLASE, 240T/KIT 336.00 07/31/13

6153522 60871 610000 130150 DILUENT, SAMPLE 6 X 500 ML 235.20 07/31/13

6153523 163349 610050 130000 SED-96355 QUICKLYTE STANDARD A 206.55 06/30/13

6153523 163350 610050 130000 SED-96354 QUICKLYTE STANDARD B 206.55 06/30/13

6153523 37725 610150 130000 DIFF-SAFE BLOOD DISPENSER,1000/PK 354.13 06/30/13

6153523 74824 610200 130000 PROBE SAMPLE 3/PK 787.48 06/30/13

6153523 100581 610200 130000 CUVETTE CARTRIDGE FOR RXL 408.37 06/30/13

6153523 109661 610200 130000 PROBE TIP & NUT FOR DIMENSION,2/PK 162.98 06/30/13

6153523 18075 610000 130150 REAGENT, LYSESM III DIFF, 1 LITER 6/CS 141.15 07/31/13

6153523 18149 610000 130150 REAGENT, ISOTON III, 20 LITER 137.70 07/31/13

6153523 18370 610000 130150 REAGENT, BUN 144.00 07/31/13

6153523 27080 610000 130150 COAGULATION SYSTEM WASH,EA 140.82 07/31/13

6153523 60850 610000 130150 REAGENT, AMYLASE, 240T/KIT 168.00 07/31/13

6153523 60871 610000 130150 DILUENT, SAMPLE 6 X 500 ML 117.60 07/31/13

6153523 67684 610000 130150 MULTISTIX 10 SG AMES 2161 BT/100 BT 260.16 07/31/13

6153523 74527 610000 130150 DIGOXIN,80T/EA 283.20 07/31/13

6153523 74666 610000 130150 VANCOMYCIN,80T/EA 188.80 07/31/13
 
Back
Top