Environmental Lady
New Member
- Joined
- Mar 22, 2018
- Messages
- 2
I only want to show dates before 12/01/18. How do I do this? This is my pivot table data: Vendor and Next Step | Number of Invoices | Total Amount | Sum of Field1 |
ANS Distributing | 4 | 1102.52 | 0 |
Emeka to Sign | 4 | 1102.52 | 0 |
11/21/2018 | 2 | 466.74 | 0 |
11/26/2018 | 1 | 296.95 | 0 |
11/28/2018 | 1 | 338.83 | 0 |
Crompco | 7 | 3811.27 | 0 |
Emeka to Sign | 7 | 3811.27 | 0 |
11/28/2018 | 2 | 1050 | 0 |
12/4/2018 | 1 | 525 | 0 |
12/5/2018 | 4 | 2236.27 | 0 |
(blank) | 0 | ||
D&H United Fuel | 13 | 2679.06 | 0 |
Emeka to Sign | 13 | 2679.06 | 0 |
11/30/2018 | 13 | 2679.06 | 0 |
Diversified (DECON) | 2 | 3562.95 | 0 |
Emeka to Sign | 2 | 3562.95 | 0 |
12/7/2018 | 1 | 2766.3 | 0 |
12/10/2018 | 1 | 796.65 | 0 |
(blank) | 0 | ||
Durand's Testing | 3 | 850 | 0 |
Emeka to Sign | 3 | 850 | 0 |
11/29/2018 | 1 | 150 | 0 |
11/30/2018 | 1 | 225 | 0 |
12/4/2018 | 1 | 475 | 0 |
Great Dane | 23 | 21095.01 | 0 |
Complete | 1 | 113.75 | 0 |
8/28/2018 | 1 | 113.75 | 0 |
Eddie to Sign - Ck this is not a duplicate | 17 | 13600 | 0 |
12/4/2018 | 17 | 13600 | 0 |
Emeka to Sign | 5 | 7381.26 | 0 |
7/17/2018 | 1 | 391.3 | 0 |
8/31/2018 | 1 | 987.41 | 0 |
9/6/2018 | 1 | 81.25 | 0 |
9/12/2018 | 1 | 1450.8 | 0 |
9/20/2018 | 1 | 4470.5 | 0 |
Guardian Fueling | 1 | 5000 | 0 |
Emeka to Sign | 1 | 5000 | 0 |
11/27/2018 | 1 | 5000 | 0 |
John W. Kennedy | 4 | 17166.96 | 0 |
Emeka to Sign | 4 | 17166.96 | 0 |
11/30/2018 | 2 | 14411.5 | 0 |
12/5/2018 | 1 | 1377.73 | 0 |
12/7/2018 | 1 | 1377.73 | 0 |
PPM Consultants | 2 | 4343.85 | 0 |
Emeka to Sign | 2 | 4343.85 | 0 |
11/29/2018 | 1 | 4037.6 | 0 |
11/30/2018 | 1 | 306.25 | 0 |
Rittner | 1 | 455.7 | 0 |
Complete | 1 | 455.7 | 0 |
6/27/2018 | 1 | 455.7 | 0 |
Sentry Compliance | 1 | 4644 | 0 |
Emeka to Sign | 1 | 4644 | 0 |
11/30/2018 | 1 | 4644 | 0 |
Tanknology | 31 | 31681.08 | 0 |
Emeka to Sign | 31 | 31681.08 | 0 |
9/4/2018 | 1 | 600 | 0 |
11/1/2018 | 12 | 17985.54 | 0 |
11/15/2018 | 1 | 231.43 | 0 |
11/28/2018 | 3 | 1474.3 | 0 |
11/30/2018 | 1 | 455 | 0 |
12/3/2018 | 1 | 275 | 0 |
12/5/2018 | 11 | 10384.81 | 0 |
12/6/2018 | 1 | 275 | 0 |
(blank) | 0 | ||
(blank) | 0 | ||
(blank) | 0 | ||
Titan Cloud Software | 1 | 19880 | 0 |
Emeka to Sign | 1 | 19880 | 0 |
12/1/2018 | 1 | 19880 | 0 |
Valley Tank Testing | 4 | 1800 | 0 |
Emeka to Sign | 4 | 1800 | 0 |
11/1/2018 | 3 | 1575 | 0 |
11/28/2018 | 1 | 225 | 0 |
(blank) | 2 | 500 | 0 |
Emeka to Sign | 2 | 500 | 0 |
11/29/2018 | 2 | 500 | 0 |
(blank) | 0 | ||
(blank) | 0 | ||
Grand Total | 99 | 118572.4 | 0 |