AnsweredAssumed Answered

Summarize with Pivot Table like view

Question asked by laguna92651 on Dec 26, 2012
Latest reply on Jan 9, 2013 by laguna92651

I need to summarize records, in both a report and browse view, that are of the form below. I need to basically do an Excel like Pivot Table of the data.

 

Record Form:

Article No Product Code Style Size UnpostedSales Yds Cost
DM13012 DM13012-XS T Shirt XS 3 15 25

 

The Table view or List view would summarize the data and show the sizes as columns. The number beneath the XS column is the total number of DM13012-XS's in the data set, 23. The Article No consists of a family of Product Codes.

 

Article No. DM13012, has the following family of Product Codes.

 

DM13012-XS

DM13012-S

DM13012-M

DM13012-L

DM13012-XL

 

Summary View desired:

Article No Style Color XS S M L XL No. Units Mfg.
DM13011 T SHIRT BLACK 23 12 20 15 8 78
DM13012 T SHIRT CHARCAOL 11 5 9 27 28 80
DM13013 T SHIRT TAUPE 15 21 16 16 23 91
DM13014 T SHIRT OCHRE 15 29 26 21 27 118
DM13015 T SHIRT WHITE 27 23 24 5 27 106
DM13016 T SHIRT MINT 24 5 19 13 15 76
DM13017 T SHIRT STRIPE 8 11 7 17 5 48
DM13041 TANK BLACK 11 28 10 24 9 82
DM13042 TANK CHARCAOL 27 30 21 13 10 101
DM13044 TANK OCHRE 27 9 19 6 24 85
DM13045 TANK WHITE 25 18 15 23 9 90
DM13047 TANK STRIPE 5 20 30 24 9 88

 

Thank you

Outcomes