Hi again, guys.
I want to summarize my data to show totals Product Type. My data table looks like this.
| Division | Major Line | #Of | On Hand | $Value |
| SASKATOON | INDH&F | 2,364 | 913,296 | $1,294,623.53 |
| EDMONTON | INDH&F | 1,899 | 709,511 | $3,045,141.61 |
| EDMONTON | HH&A | 3,314 | 372,211 | $822,220.58 |
| SASKATOON | HH&A | 2,932 | 188,675 | $610,591.56 |
| REGINA | INDH&F | 1,606 | 187,312 | $460,217.24 |
| OSHAWA | INDH&F | 326 | 122,306 | $304,935.11 |
| WINNIPEG | INDH&F | 756 | 120,250 | $321,952.13 |
| NANAIMO | HH&A | 2,292 | 111,302 | $279,006.20 |
| VANCOUVER | HH&A | 2,605 | 111,006 | $420,060.59 |
| OSHAWA | BLTPRD | 814 | 108,688 | $1,394,417.33 |
| SUDBURY | INDH&F | 814 | 107,053 | $436,634.51 |
| REGINA | HH&A | 1,844 | 102,821 | $293,835.49 |
| SARNIA | INDH&F | 655 | 83,050 | $408,495.01 |
| EDMONTON | GASKET | 166 | 82,777 | $159,167.16 |
When I build my summary table grouping by MAJOR LINE the summary table looks like this. AWESOME!
| Major Line | #Of | On Hand | $Value |
| FACMNT | 47 | 7,776 | $3,797.67 |
| SAFETY | 119 | 2,123 | $39,988.58 |
| GASKET | 545 | 254,651 | $564,629.62 |
| BLTPRD | 1,617 | 338,322 | $3,565,487.04 |
| HH&A | 8,423 | 1,143,301 | $3,732,056.07 |
| INDH&F | 6,392 | 2,559,086 | $7,318,632.47 |
When I pick a specific division, like Cranbrook, in another object it filters the data and only shows data for Cranbrook
CRANBROOK DIVISION
| Major Line | #Of | On Hand | $Value |
| GASKET | 5 | 111 | $217.52 |
| BLTPRD | 6 | 347 | $1,731.92 |
| INDH&F | 617 | 13,854 | $23,346.45 |
| HH&A | 1,639 | 25,635 | $69,763.17 |
But as you can see I have lost some of the fields: Cranbrook doesn't stock "FACMNT" or "SAFETY" inventory so those Major Lines are missing from their list.
QUESTION:
HOW CAN I MAKE THE LIST SHOW ALL MAJOR LINES EVEN IF THE DIVISION DOESN'T STOCK IT?
LIKE THIS...
CRANBROOK DIVISION
| Major Line | #Of | On Hand | $Value |
| FACMNT | 0 | 0 | $0.00 |
| SAFETY | 0 | 0 | $0.00 |
| GASKET | 5 | 111 | $217.52 |
| BLTPRD | 6 | 347 | $1,731.92 |
| INDH&F | 617 | 13,854 | $23,346.45 |
| HH&A | 1,639 | 25,635 | $69,763.17 |
