Forum Discussion
Solved
SumX Incorrect totals between different years.
Trying to Sumx measure "ptl cost" , "2025 Cost", "Savings". I need to be able to sum the total of selections in the table.
Due to work security, i can not upload a copy of the file. I will post a table with data and all forumlas in order.
Avg Rate = Average 2024 Rates
2024 Sum Cost = Sum 2024 Rates
2024 Sum lbs = Sum 2024 lbs
2024 Avg lbs = Average 2024 lbs
Trucks = Count 2024 lbs
+4% lbs = CALCULATE(AVERAGE(Data[2024 LBS]))*0.04+AVERAGE(Data[2024 LBS])
Ptl Trucks = ROUNDUP(CALCULATE(DIVIDE(SUM(Data[2024 LBS]),Data[+4% lbs])),0)
Ptl Cost = CALCULATE([Ptl Trucks]*AVERAGE(Data[2024 Rates]))
Ptl Save = CALCULATE(SUM(Data[2024 Rates])-[Ptl Cost],Data[2024 Rates])
2025 Svg lbs = Average 2025 lbs
2025 Svg lbs = Average 2025 lbs
2025 Trucks = ROUNDUP(CALCULATE(DIVIDE(SUM(Data[2024 total lbs]),AVERAGE(Data[2025 LBS]))),0)
2025 Cost = CALCULATE(Data[2025 Trucks]*AVERAGE(Data[Trip Cost]))
Savings = CALCULATE(Data[2024 Cost]-Data[2025 Cost])
SumX is giving me incorrect total for "sumx ptl cost"
SumX is giving me the same incorrect total for "Savings"
SumX is giving me a blank value for "sumx 2025"
sumx ptl cost = CALCULATE(SUMX(Data,Data[Ptl Cost]),ALLSELECTED(Data))
Sumx Savings = CALCULATE(SUMX(Data,Data[Savings]),ALLSELECTED(Data))
sumx 2025 = CALCULATE(SUMX(data,Data[2025 Cost]),ALLSELECTED(data))
Hi GVallentgoed ,
Try using the following formula:
sumx ptl cost = CALCULATE(SUMX(VALUES('Data'[Destination Name]),Data[Ptl Cost]),ALLSELECTED(Data))Sumx Savings = CALCULATE(SUMX(VALUES('Data'[Destination Name]),'Data'[Savings]),ALLSELECTED('Data'))sumx 2025 = CALCULATE(SUMX(VALUES('Data'[Destination Name]),Data[2025 Cost]),ALLSELECTED(data))Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
12 Replies
Rate Year Trip Cost Latest Delivery Destination Name LBS 2024 LBS 2025 LBS 2024 Rates 2025 Rates 2024 $ 589.07 2024-01-03 09:00 COSTCO DEPOT 572 17,012.63 17,012.63 $ 589.07 2024 $ 589.07 2024-01-05 09:00 COSTCO DEPOT 572 10,326.75 10,326.75 $ 589.07 2024 $ 589.07 2024-01-10 09:00 COSTCO DEPOT 572 13,589.50 13,589.50 $ 589.07 2024 $ 589.07 2024-01-12 05:00 COSTCO DEPOT 571 31,970.00 31,970.00 $ 589.07 2024 $ 589.07 2024-01-12 05:30 COSTCO DEPOT 571 33,693.56 33,693.56 $ 589.07 2024 $ 589.07 2024-01-12 09:00 COSTCO DEPOT 572 12,697.50 12,697.50 $ 589.07 2024 $ 4,973.89 2024-01-12 09:30 COSTCO DEPOT 1034 DRY 16,894.34 16,894.34 $ 4,973.89 2024 $ 5,825.17 2024-01-13 08:15 COSTCO DEPOT 76 10,158.00 10,158.00 $ 5,825.17 2024 $ 1,091.89 2024-01-15 09:15 COSTCO DEPOT 574 WET 12,697.50 12,697.50 $ 1,091.89 2024 $ 1,091.89 2024-01-15 09:45 COSTCO DEPOT 574 WET 21,849.50 21,849.50 $ 1,091.89 2024 $ 589.07 2024-01-16 10:00 COSTCO DEPOT 572 12,697.50 12,697.50 $ 589.07 2024 $ 1,091.89 2024-01-18 09:15 COSTCO DEPOT 574 WET 16,930.00 16,930.00 $ 1,091.89 2024 $ 589.07 2024-01-18 10:00 COSTCO DEPOT 572 16,930.00 16,930.00 $ 589.07 2024 $ 589.07 2024-01-19 06:00 COSTCO DEPOT 571 41,961.42 41,961.42 $ 589.07 2024 $ 4,973.89 2024-01-20 06:00 COSTCO DEPOT 1034 DRY 15,612.90 15,612.90 $ 4,973.89 2024 $ 1,091.89 2024-01-22 08:45 COSTCO DEPOT 574 WET 16,808.00 16,808.00 $ 1,091.89 2024 $ 5,825.17 2024-01-23 05:45 COSTCO DEPOT 76 30,745.69 30,745.69 $ 5,825.17 2024 $ 1,091.89 2024-01-25 09:15 COSTCO DEPOT 574 WET 33,822.25 33,822.25 $ 1,091.89 2024 $ 4,973.89 2024-01-25 09:30 COSTCO DEPOT 1034 DRY 40,714.50 40,714.50 $ 4,973.89 2024 $ 589.07 2024-01-25 09:30 COSTCO DEPOT 572 33,822.25 33,822.25 $ 589.07 2024 $ 5,825.17 2024-01-25 11:34 COSTCO DEPOT 76 13,778.75 13,778.75 $ 5,825.17 2024 $ 4,973.89 2024-01-29 05:00 COSTCO DEPOT 1034 DRY 25,282.88 25,282.88 $ 4,973.89 2024 $ 589.07 2024-01-29 05:00 COSTCO DEPOT 571 30,555.00 30,555.00 $ 589.07 2024 $ 589.07 2024-01-30 08:00 COSTCO DEPOT 572 30,872.75 30,872.75 $ 589.07 2024 $ 1,091.89 2024-01-30 08:45 COSTCO DEPOT 574 WET 27,486.75 27,486.75 $ 1,091.89 2024 $ 4,973.89 2024-02-01 05:00 COSTCO DEPOT 1034 DRY 25,070.88 25,070.88 $ 4,973.89 2024 $ 1,091.89 2024-02-01 08:45 COSTCO DEPOT 574 WET 23,527.06 23,527.06 $ 1,091.89 2024 $ 5,825.17 2024-02-01 09:00 COSTCO DEPOT 76 20,319.25 20,319.25 $ 5,825.17 2024 $ 589.07 2024-02-01 11:00 COSTCO DEPOT 572 23,111.06 23,111.06 $ 589.07 2024 $ 589.07 2024-02-02 05:00 COSTCO DEPOT 571 30,555.00 30,555.00 $ 589.07 2024 $ 589.07 2024-02-02 07:30 COSTCO DEPOT 571 21,326.00 21,326.00 $ 589.07 2024 $ 589.07 2024-02-02 11:00 COSTCO DEPOT 572 16,731.31 16,731.31 $ 589.07 2024 $ 4,973.89 2024-02-05 05:00 COSTCO DEPOT 1034 DRY 20,590.38 20,590.38 $ 4,973.89 2024 $ 5,825.17 2024-02-05 12:42 COSTCO DEPOT 76 28,415.63 28,415.63 $ 5,825.17 2024 $ 589.07 2024-02-06 06:30 COSTCO DEPOT 572 33,406.25 33,406.25 $ 589.07 2024 $ 1,091.89 2024-02-06 09:15 COSTCO DEPOT 574 WET 33,822.25 33,822.25 $ 1,091.89 2024 $ 5,825.17 2024-02-08 07:36 COSTCO DEPOT 76 21,820.50 21,820.50 $ 5,825.17 2024 $ 589.07 2024-02-08 08:00 COSTCO DEPOT 572 29,260.38 29,260.38 $ 589.07 2024 $ 1,091.89 2024-02-08 08:45 COSTCO DEPOT 574 WET 23,527.06 23,527.06 $ 1,091.89 2024 $ 589.07 2024-02-08 10:00 COSTCO DEPOT 572 10,816.00 10,816.00 $ 589.07 2024 $ 4,973.89 2024-02-08 11:00 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 4,973.89 2024-02-09 06:00 COSTCO DEPOT 1034 DRY 44,593.75 44,593.75 $ 4,973.89 2024 $ 589.07 2024-02-10 05:30 COSTCO DEPOT 571 30,555.00 30,555.00 $ 589.07 2024 $ 589.07 2024-02-13 06:30 COSTCO DEPOT 572 24,576.56 24,576.56 $ 589.07 2024 $ 589.07 2024-02-13 06:30 COSTCO DEPOT 571 23,086.89 23,086.89 $ 589.07 2024 $ 4,973.89 2024-02-13 11:05 COSTCO DEPOT 1035 WET 20,820.00 20,820.00 $ 4,973.89 2024 $ 4,973.89 2024-02-15 05:00 COSTCO DEPOT 1034 DRY 16,800.15 16,800.15 $ 4,973.89 2024 $ 1,091.89 2024-02-15 09:15 COSTCO DEPOT 574 WET 25,284.94 25,284.94 $ 1,091.89 2024 $ 4,973.89 2024-02-16 11:35 COSTCO DEPOT 1035 WET 20,820.00 20,820.00 $ 4,973.89 2024 $ 4,973.89 2024-02-20 07:30 COSTCO DEPOT 1034 DRY 24,341.14 24,341.14 $ 4,973.89 2024 $ 589.07 2024-02-20 09:30 COSTCO DEPOT 572 17,676.25 17,676.25 $ 589.07 2024 $ 4,973.89 2024-02-21 10:35 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 1,091.89 2024-02-22 09:15 COSTCO DEPOT 574 WET 24,025.00 24,025.00 $ 1,091.89 2024 $ 589.07 2024-02-22 10:00 COSTCO DEPOT 572 21,908.75 21,908.75 $ 589.07 2024 $ 589.07 2024-02-23 08:00 COSTCO DEPOT 571 36,726.34 36,726.34 $ 589.07 2024 $ 589.07 2024-02-26 05:00 COSTCO DEPOT 571 31,918.00 31,918.00 $ 589.07 2024 $ 4,973.89 2024-02-26 05:19 COSTCO DEPOT 1034 DRY 39,187.70 39,187.70 $ 4,973.89 2024 $ 1,091.89 2024-02-27 09:15 COSTCO DEPOT 574 WET 27,372.19 27,372.19 $ 1,091.89 2024 $ 589.07 2024-02-27 11:00 COSTCO DEPOT 572 26,580.25 26,580.25 $ 589.07 2024 $ 589.07 2024-02-28 05:30 COSTCO DEPOT 571 27,848.77 27,848.77 $ 589.07 2024 $ 4,973.89 2024-03-03 21:14 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 5,825.17 2024-03-04 06:00 COSTCO DEPOT 76 33,583.06 33,583.06 $ 5,825.17 2024 $ 4,973.89 2024-03-04 11:00 COSTCO DEPOT 1034 DRY 35,962.33 35,962.33 $ 4,973.89 2024 $ 4,973.89 2024-03-04 12:05 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 589.07 2024-03-05 06:30 COSTCO DEPOT 571 33,047.53 33,047.53 $ 589.07 2024 $ 4,973.89 2024-03-05 07:00 COSTCO DEPOT 1034 DRY 41,568.44 41,568.44 $ 4,973.89 2024 $ 589.07 2024-03-05 07:30 COSTCO DEPOT 571 31,401.38 31,401.38 $ 589.07 2024 $ 1,091.89 2024-03-05 09:15 COSTCO DEPOT 574 WET 21,927.94 21,927.94 $ 1,091.89 2024 $ 589.07 2024-03-05 10:00 COSTCO DEPOT 572 29,601.00 29,601.00 $ 589.07 2024 $ 4,973.89 2024-03-07 07:00 COSTCO DEPOT 1034 DRY 19,782.45 19,782.45 $ 4,973.89 2024 $ 4,973.89 2024-03-07 08:00 COSTCO DEPOT 1034 DRY 31,677.81 31,677.81 $ 4,973.89 2024 $ 589.07 2024-03-07 11:00 COSTCO DEPOT 572 11,851.00 11,851.00 $ 589.07 2024 $ 589.07 2024-03-08 05:00 COSTCO DEPOT 571 42,449.40 42,449.40 $ 589.07 2024 $ 589.07 2024-03-08 10:00 COSTCO DEPOT 572 18,227.81 18,227.81 $ 589.07 2024 $ 5,825.17 2024-03-09 09:15 COSTCO DEPOT 76 41,554.06 41,554.06 $ 5,825.17 2024 $ 589.07 2024-03-11 07:30 COSTCO DEPOT 571 30,555.00 30,555.00 $ 589.07 2024 $ 4,973.89 2024-03-11 10:00 COSTCO DEPOT 1034 DRY 34,920.00 34,920.00 $ 4,973.89 2024 $ 4,973.89 2024-03-11 10:35 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 5,825.17 2024-03-11 12:00 COSTCO DEPOT 76 27,624.63 27,624.63 $ 5,825.17 2024 $ 589.07 2024-03-12 06:00 COSTCO DEPOT 572 22,174.25 22,174.25 $ 589.07 2024 $ 1,091.89 2024-03-12 08:15 COSTCO DEPOT 574 WET 34,025.25 34,025.25 $ 1,091.89 2024 $ 589.07 2024-03-12 10:00 COSTCO DEPOT 571 31,748.89 31,748.89 $ 589.07 2024 $ 589.07 2024-03-12 11:00 COSTCO DEPOT 572 12,697.50 12,697.50 $ 589.07 2024 $ 5,825.17 2024-03-13 06:00 COSTCO DEPOT 76 22,536.69 22,536.69 $ 5,825.17 2024 $ 5,825.17 2024-03-13 06:00 COSTCO DEPOT 76 25,098.75 25,098.75 $ 5,825.17 2024 $ 589.07 2024-03-14 05:30 COSTCO DEPOT 571 36,152.59 36,152.59 $ 589.07 2024 $ 589.07 2024-03-14 06:00 COSTCO DEPOT 572 22,719.88 22,719.88 $ 589.07 2024 $ 1,091.89 2024-03-14 08:15 COSTCO DEPOT 574 WET 20,071.25 20,071.25 $ 1,091.89 2024 $ 589.07 2024-03-14 08:30 COSTCO DEPOT 571 45,110.00 45,110.00 $ 589.07 2024 $ 589.07 2024-03-15 05:00 COSTCO DEPOT 571 45,110.00 45,110.00 $ 589.07 2024 $ 5,825.17 2024-03-15 08:00 COSTCO DEPOT 76 29,463.75 29,463.75 $ 5,825.17 2024 $ 4,973.89 2024-03-15 08:30 COSTCO DEPOT 1034 DRY 40,376.25 40,376.25 $ 4,973.89 2024 $ 589.07 2024-03-15 08:30 COSTCO DEPOT 572 12,697.50 12,697.50 $ 589.07 2024 $ 4,973.89 2024-03-16 07:00 COSTCO DEPOT 1034 DRY 20,081.83 20,081.83 $ 4,973.89 2024 $ 5,825.17 2024-03-16 09:15 COSTCO DEPOT 76 22,548.19 22,548.19 $ 5,825.17 2024 $ 589.07 2024-03-18 05:00 COSTCO DEPOT 571 31,646.25 31,646.25 $ 589.07 2024 $ 4,973.89 2024-03-18 06:05 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 5,825.17 2024-03-18 06:45 COSTCO DEPOT 557 WET 20,820.00 20,820.00 $ 5,825.17 2024 $ 589.07 2024-03-18 09:00 COSTCO DEPOT 571 42,024.75 42,024.75 $ 589.07
2024 $ 589.07 2024-03-19 05:00 COSTCO DEPOT 571 30,541.57 30,541.57 $ 589.07 2024 $ 589.07 2024-03-19 05:00 COSTCO DEPOT 571 37,238.44 37,238.44 $ 589.07 2024 $ 1,091.89 2024-03-19 09:15 COSTCO DEPOT 574 WET 30,588.50 30,588.50 $ 1,091.89 2024 $ 589.07 2024-03-19 10:00 COSTCO DEPOT 572 30,588.50 30,588.50 $ 589.07 2024 $ 1,091.89 2024-03-21 07:15 COSTCO DEPOT 574 WET 30,588.50 30,588.50 $ 1,091.89 2024 $ 589.07 2024-03-21 10:00 COSTCO DEPOT 572 28,660.25 28,660.25 $ 589.07 2024 $ 4,973.89 2024-03-21 11:00 COSTCO DEPOT 1034 DRY 21,402.75 21,402.75 $ 4,973.89 2024 $ 589.07 2024-03-22 05:00 COSTCO DEPOT 571 27,951.92 27,951.92 $ 589.07 2024 $ 1,091.89 2024-03-22 09:45 COSTCO DEPOT 574 WET 28,182.44 28,182.44 $ 1,091.89 2024 $ 1,091.89 2024-03-22 09:45 COSTCO DEPOT 574 WET 28,182.44 28,182.44 $ 1,091.89 2024 $ 589.07 2024-03-22 10:00 COSTCO DEPOT 572 28,660.25 28,660.25 $ 589.07 2024 $ 4,973.89 2024-03-25 06:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 1,091.89 2024-03-26 09:15 COSTCO DEPOT 574 WET 28,182.44 28,182.44 $ 1,091.89 2024 $ 589.07 2024-03-26 10:00 COSTCO DEPOT 571 45,110.00 45,110.00 $ 589.07 2024 $ 589.07 2024-03-26 11:00 COSTCO DEPOT 572 22,174.25 22,174.25 $ 589.07 2024 $ 5,825.17 2024-04-02 06:15 COSTCO DEPOT 557 WET 34,700.00 34,700.00 $ 5,825.17 2024 $ 5,825.17 2024-04-02 09:00 COSTCO DEPOT 76 29,042.69 29,042.69 $ 5,825.17 2024 $ 4,973.89 2024-04-02 10:35 COSTCO DEPOT 1035 WET 45,110.00 45,110.00 $ 4,973.89 2024 $ 4,973.89 2024-04-04 04:47 COSTCO DEPOT 1034 DRY 18,696.50 18,696.50 $ 4,973.89 2024 $ 4,973.89 2024-04-08 05:00 COSTCO DEPOT 1034 DRY 20,804.25 20,804.25 $ 4,973.89 2024 $ 5,825.17 2024-04-08 06:00 COSTCO DEPOT 76 12,373.50 12,373.50 $ 5,825.17 2024 $ 589.07 2024-04-09 10:00 COSTCO DEPOT 572 18,079.00 18,079.00 $ 589.07 2024 $ 589.07 2024-04-10 05:00 COSTCO DEPOT 571 20,820.00 20,820.00 $ 589.07 2024 $ 589.07 2024-04-12 05:30 COSTCO DEPOT 571 32,381.25 32,381.25 $ 589.07 2024 $ 589.07 2024-04-12 05:30 COSTCO DEPOT 571 32,381.25 32,381.25 $ 589.07 2024 $ 589.07 2024-04-12 06:30 COSTCO DEPOT 571 20,820.00 20,820.00 $ 589.07 2024 $ 589.07 2024-04-16 06:00 COSTCO DEPOT 572 28,660.25 28,660.25 $ 589.07 2024 $ 1,091.89 2024-04-16 08:45 COSTCO DEPOT 574 WET 28,182.44 28,182.44 $ 1,091.89 2024 $ 4,973.89 2024-04-17 09:35 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 589.07 2024-04-19 05:30 COSTCO DEPOT 571 21,337.88 21,337.88 $ 589.07 2024 $ 4,973.89 2024-04-22 06:05 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 589.07 2024-04-23 10:00 COSTCO DEPOT 572 28,660.25 28,660.25 $ 589.07 2024 $ 1,091.89 2024-04-23 10:15 COSTCO DEPOT 574 WET 28,182.44 28,182.44 $ 1,091.89 2024 $ 589.07 2024-04-24 06:00 COSTCO DEPOT 571 21,950.26 21,950.26 $ 589.07 2024 $ 4,973.89 2024-04-25 11:05 COSTCO DEPOT 1035 WET 34,700.00 34,700.00 $ 4,973.89 2024 $ 4,973.89 2024-04-26 11:35 COSTCO DEPOT 1035 WET 20,820.00 20,820.00 $ 4,973.89 2024 $ 589.07 2024-04-30 05:00 COSTCO DEPOT 571 25,069.63 25,069.63 $ 589.07 2024 $ 4,973.89 2024-05-01 07:00 COSTCO DEPOT 1034 DRY 23,905.05 23,905.05 $ 4,973.89 2024 $ 5,825.17 2024-05-02 06:15 COSTCO DEPOT 557 WET 20,820.00 20,820.00 $ 5,825.17 2024 $ 589.07 2024-05-02 10:00 COSTCO DEPOT 572 21,177.31 21,177.31 $ 589.07 2024 $ 4,973.89 2024-05-02 11:05 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 1,091.89 2024-05-04 08:15 COSTCO DEPOT 574 WET 22,720.25 22,720.25 $ 1,091.89 2024 $ 4,973.89 2024-05-06 06:05 COSTCO DEPOT 1035 WET 29,495.00 29,495.00 $ 4,973.89 2024 $ 589.07 2024-05-08 06:30 COSTCO DEPOT 571 26,795.33 26,795.33 $ 589.07 2024 $ 1,091.89 2024-05-11 04:45 COSTCO DEPOT 574 WET 38,977.50 38,977.50 $ 1,091.89 2024 $ 589.07 2024-05-11 08:00 COSTCO DEPOT 572 13,162.06 13,162.06 $ 589.07 2024 $ 4,973.89 2024-05-13 06:00 COSTCO DEPOT 1034 DRY 40,924.00 40,924.00 $ 4,973.89 2024 $ 5,825.17 2024-05-13 06:15 COSTCO DEPOT 557 WET 20,820.00 20,820.00 $ 5,825.17 2024 $ 5,825.17 2024-05-13 08:00 COSTCO DEPOT 76 41,264.69 41,264.69 $ 5,825.17 2024 $ 4,973.89 2024-05-14 10:35 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-05-14 11:00 COSTCO DEPOT 572 22,667.00 22,667.00 $ 589.07 2024 $ 589.07 2024-05-15 07:30 COSTCO DEPOT 572 32,737.50 32,737.50 $ 589.07 2024 $ 1,091.89 2024-05-15 07:45 COSTCO DEPOT 574 WET 22,667.00 22,667.00 $ 1,091.89 2024 $ 1,091.89 2024-05-15 08:45 COSTCO DEPOT 574 WET 32,737.50 32,737.50 $ 1,091.89 2024 $ 589.07 2024-05-15 11:00 COSTCO DEPOT 572 32,737.50 32,737.50 $ 589.07 2024 $ 589.07 2024-05-17 07:00 COSTCO DEPOT 572 11,333.50 11,333.50 $ 589.07 2024 $ 589.07 2024-05-18 08:00 COSTCO DEPOT 572 11,333.50 11,333.50 $ 589.07 2024 $ 1,091.89 2024-05-18 08:00 COSTCO DEPOT 574 WET 11,333.50 11,333.50 $ 1,091.89 2024 $ 1,091.89 2024-05-21 07:45 COSTCO DEPOT 574 WET 11,333.50 11,333.50 $ 1,091.89 2024 $ 589.07 2024-05-21 10:00 COSTCO DEPOT 572 22,667.01 22,667.01 $ 589.07 2024 $ 4,973.89 2024-05-21 11:05 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 4,973.89 2024-05-21 11:05 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 589.07 2024-05-22 05:30 COSTCO DEPOT 571 22,340.82 22,340.82 $ 589.07 2024 $ 5,825.17 2024-05-22 08:45 COSTCO DEPOT 557 WET 34,700.00 34,700.00 $ 5,825.17 2024 $ 589.07 2024-05-23 07:30 COSTCO DEPOT 571 45,110.00 45,110.00 $ 589.07 2024 $ 589.07 2024-05-23 11:00 COSTCO DEPOT 572 27,172.25 27,172.25 $ 589.07 2024 $ 589.07 2024-05-24 06:00 COSTCO DEPOT 572 14,322.69 14,322.69 $ 589.07 2024 $ 1,091.89 2024-05-24 07:45 COSTCO DEPOT 574 WET 20,615.31 20,615.31 $ 1,091.89 2024 $ 1,091.89 2024-05-24 08:15 COSTCO DEPOT 574 WET 11,333.50 11,333.50 $ 1,091.89 2024 $ 589.07 2024-05-24 11:00 COSTCO DEPOT 572 23,212.56 23,212.56 $ 589.07 2024 $ 4,973.89 2024-05-25 09:00 COSTCO DEPOT 1034 DRY 25,961.85 25,961.85 $ 4,973.89 2024 $ 4,973.89 2024-05-27 08:35 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 1,091.89 2024-05-27 09:45 COSTCO DEPOT 574 WET 19,006.50 19,006.50 $ 1,091.89 2024 $ 589.07 2024-05-27 11:00 COSTCO DEPOT 572 19,798.44 19,798.44 $ 589.07 2024 $ 589.07 2024-05-28 11:00 COSTCO DEPOT 572 11,333.50 11,333.50 $ 589.07 2024 $ 589.07 2024-05-30 07:30 COSTCO DEPOT 572 15,838.75 15,838.75 $ 589.07 2024 $ 1,091.89 2024-05-30 07:45 COSTCO DEPOT 574 WET 20,889.75 20,889.75 $ 1,091.89 2024 $ 1,091.89 2024-05-30 08:45 COSTCO DEPOT 574 WET 17,422.63 17,422.63 $ 1,091.89 2024 $ 589.07 2024-05-30 11:00 COSTCO DEPOT 572 21,914.75 21,914.75 $ 589.07 2024 $ 5,825.17 2024-05-31 06:00 COSTCO DEPOT 76 12,126.50 12,126.50 $ 5,825.17 2024 $ 589.07 2024-06-03 05:00 COSTCO DEPOT 571 20,580.82 20,580.82 $ 589.07 2024 $ 589.07 2024-06-03 06:00 COSTCO DEPOT 572 18,623.00 18,623.00 $ 589.07 2024 $ 4,973.89 2024-06-03 10:35 COSTCO DEPOT 1035 WET 34,700.00 34,700.00 $ 4,973.89 2024 $ 1,091.89 2024-06-04 07:45 COSTCO DEPOT 574 WET 21,877.79 21,877.79 $ 1,091.89 2024 $ 589.07 2024-06-04 11:00 COSTCO DEPOT 572 18,214.56 18,214.56 $ 589.07 2024 $ 4,973.89 2024-06-05 05:00 COSTCO DEPOT 1034 DRY 21,492.25 21,492.25 $ 4,973.89 2024 $ 589.07 2024-06-06 07:30 COSTCO DEPOT 572 10,581.25 10,581.25 $ 589.07 2024 $ 589.07 2024-06-06 09:30 COSTCO DEPOT 572 16,190.72 16,190.72 $ 589.07 2024 $ 1,091.89 2024-06-06 09:45 COSTCO DEPOT 574 WET 12,143.04 12,143.04 $ 1,091.89 2024 $ 589.07 2024-06-07 11:00 COSTCO DEPOT 572 13,529.50 13,529.50 $ 589.07 2024 $ 1,091.89 2024-06-10 09:15 COSTCO DEPOT 574 WET 25,538.25 25,538.25 $ 1,091.89 2024 $ 589.07 2024-06-11 06:30 COSTCO DEPOT 572 18,214.56 18,214.56 $ 589.07 2024 $ 589.07 2024-06-11 10:00 COSTCO DEPOT 572 28,143.69 28,143.69 $ 589.07 2024 $ 4,973.89 2024-06-11 11:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-06-13 07:30 COSTCO DEPOT 572 17,472.00 17,472.00 $ 589.07 2024 $ 1,091.89 2024-06-13 09:15 COSTCO DEPOT 574 WET 31,233.54 31,233.54 $ 1,091.89 2024 $ 589.07 2024-06-13 11:00 COSTCO DEPOT 572 16,190.72 16,190.72 $ 589.07 2024 $ 5,825.17 2024-06-13 11:45 COSTCO DEPOT 557 WET 34,700.00 34,700.00 $ 5,825.17 2024 $ 1,091.89 2024-06-14 07:45 COSTCO DEPOT 574 WET 26,259.63 26,259.63 $ 1,091.89 2024 $ 589.07 2024-06-14 10:00 COSTCO DEPOT 572 23,850.30 23,850.30 $ 589.07 2024 $ 5,825.17 2024-06-15 05:15 COSTCO DEPOT 76 17,468.06 17,468.06 $ 5,825.17 2024 $ 4,973.89 2024-06-17 05:00 COSTCO DEPOT 1034 DRY 14,571.65 14,571.65 $ 4,973.89 2024 $ 4,973.89 2024-06-17 06:30 COSTCO DEPOT 1034 DRY 29,361.37 29,361.37 $ 4,973.89 2024 $ 5,825.17 2024-06-17 08:00 COSTCO DEPOT 76 15,785.95 15,785.95 $ 5,825.17 2024 $ 4,973.89 2024-06-17 08:30 COSTCO DEPOT 1034 DRY 17,647.50 17,647.50 $ 4,973.89 2024 $ 1,091.89 2024-06-18 07:15 COSTCO DEPOT 574 WET 26,209.19 26,209.19 $ 1,091.89 2024 $ 4,973.89 2024-06-18 11:05 COSTCO DEPOT 1035 WET 34,700.00 34,700.00 $ 4,973.89 2024 $ 589.07 2024-06-19 06:00 COSTCO DEPOT 572 21,504.69 21,504.69 $ 589.07 2024 $ 589.07 2024-06-19 10:00 COSTCO DEPOT 572 10,845.00 10,845.00 $ 589.07 2024 $ 1,091.89 2024-06-20 09:45 COSTCO DEPOT 574 WET 20,629.19 20,629.19 $ 1,091.89 2024 $ 1,091.89 2024-06-20 13:00 COSTCO DEPOT 573 DRY 22,555.00 22,555.00 $ 1,091.89 2024 $ 4,973.89 2024-06-21 07:30 COSTCO DEPOT 1034 DRY 33,536.50 33,536.50 $ 4,973.89 2024 $ 5,825.17 2024-06-21 15:00 COSTCO DEPOT 76 23,413.25 23,413.25 $ 5,825.17 2024 $ 589.07 2024-06-24 05:30 COSTCO DEPOT 571 20,372.50 20,372.50 $ 589.07 2024 $ 4,973.89 2024-06-24 06:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-06-25 11:00 COSTCO DEPOT 572 20,463.04 20,463.04 $ 589.07 2024 $ 589.07 2024-06-26 07:30 COSTCO DEPOT 572 23,366.82 23,366.82 $ 589.07 2024 $ 1,091.89 2024-06-27 07:15 COSTCO DEPOT 574 WET 23,382.24 23,382.24 $ 1,091.89 2024 $ 589.07 2024-06-28 06:30 COSTCO DEPOT 572 16,151.38 16,151.38 $ 589.07 2024 $ 589.07 2024-06-28 11:00 COSTCO DEPOT 572 10,119.20 10,119.20 $ 589.07 2024 $ 5,825.17 2024-06-29 06:15 COSTCO DEPOT 76 10,523.97 10,523.97 $ 5,825.17 2024 $ 4,973.89 2024-06-29 07:00 COSTCO DEPOT 1034 DRY 22,667.01 22,667.01 $ 4,973.89 2024 $ 5,825.17 2024-06-29 10:15 COSTCO DEPOT 557 WET 34,700.00 34,700.00 $ 5,825.17 2024 $ 1,091.89 2024-07-02 09:30 COSTCO DEPOT 573 DRY 21,179.71 21,179.71 $ 1,091.89 2024 $ 589.07 2024-07-03 06:00 COSTCO DEPOT 572 15,687.70 15,687.70 $ 589.07 2024 $ 589.07 2024-07-05 10:00 COSTCO DEPOT 572 20,913.69 20,913.69 $ 589.07 2024 $ 4,973.89 2024-07-05 10:30 COSTCO DEPOT 1034 DRY 38,801.89 38,801.89 $ 4,973.89 2024 $ 5,825.17 2024-07-06 09:15 COSTCO DEPOT 76 26,372.90 26,372.90 $ 5,825.17 2024 $ 589.07 2024-07-08 05:30 COSTCO DEPOT 571 22,880.58 22,880.58 $ 589.07 2024 $ 4,973.89 2024-07-08 06:00 COSTCO DEPOT 1034 DRY 31,435.28 31,435.28 $ 4,973.89 2024 $ 1,091.89 2024-07-08 07:15 COSTCO DEPOT 574 WET 15,844.75 15,844.75 $ 1,091.89 2024 $ 1,091.89 2024-07-08 08:45 COSTCO DEPOT 574 WET 16,487.27 16,487.27 $ 1,091.89 2024 $ 1,091.89 2024-07-08 09:30 COSTCO DEPOT 573 DRY 33,767.14 33,767.14 $ 1,091.89 2024 $ 4,973.89 2024-07-11 06:00 COSTCO DEPOT 1034 DRY 11,210.90 11,210.90 $ 4,973.89 2024 $ 1,091.89 2024-07-11 07:00 COSTCO DEPOT 573 DRY 22,972.57 22,972.57 $ 1,091.89 2024 $ 4,973.89 2024-07-11 11:35 COSTCO DEPOT 1035 WET 20,820.00 20,820.00 $ 4,973.89 2024 $ 4,973.89 2024-07-12 05:00 COSTCO DEPOT 1034 DRY 13,301.52 13,301.52 $ 4,973.89 2024 $ 5,825.17 2024-07-13 07:15 COSTCO DEPOT 76 13,985.42 13,985.42 $ 5,825.17 2024 $ 1,091.89 2024-07-13 11:30 COSTCO DEPOT 573 DRY 26,025.00 26,025.00 $ 1,091.89 2024 $ 589.07 2024-07-15 05:00 COSTCO DEPOT 571 20,820.00 20,820.00 $ 589.07 2024 $ 5,825.17 2024-07-15 08:15 COSTCO DEPOT 557 WET 20,820.00 20,820.00 $ 5,825.17 2024 $ 589.07 2024-07-16 06:30 COSTCO DEPOT 571 23,653.76 23,653.76 $ 589.07 2024 $ 4,973.89 2024-07-16 07:30 COSTCO DEPOT 1034 DRY 18,544.70 18,544.70 $ 4,973.89 2024 $ 5,825.17 2024-07-17 07:00 COSTCO DEPOT 76 21,488.13 21,488.13 $ 5,825.17 2024 $ 589.07 2024-07-19 07:30 COSTCO DEPOT 572 30,703.73 30,703.73 $ 589.07 2024 $ 1,091.89 2024-07-19 09:15 COSTCO DEPOT 574 WET 21,797.06 21,797.06 $ 1,091.89 2024 $ 1,091.89 2024-07-19 09:36 COSTCO DEPOT 573 DRY 33,707.21 33,707.21 $ 1,091.89 2024 $ 589.07 2024-07-19 10:00 COSTCO DEPOT 572 17,405.02 17,405.02 $ 589.07 2024 $ 4,973.89 2024-07-19 10:35 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 1,091.89 2024-07-20 06:45 COSTCO DEPOT 574 WET 21,452.70 21,452.70 $ 1,091.89 2024 $ 4,973.89 2024-07-22 11:35 COSTCO DEPOT 1035 WET 20,820.00 20,820.00 $ 4,973.89 2024 $ 4,973.89 2024-07-24 08:00 COSTCO DEPOT 1034 DRY 13,762.11 13,762.11 $ 4,973.89 2024 $ 4,973.89 2024-07-24 11:30 COSTCO DEPOT 1034 DRY 24,543.63 24,543.63 $ 4,973.89 2024 $ 1,091.89 2024-07-24 23:59 COSTCO DEPOT 573 DRY 27,040.25 27,040.25 $ 1,091.89 2024 $ 4,973.89 2024-07-25 06:00 COSTCO DEPOT 1034 DRY 20,560.83 20,560.83 $ 4,973.89 2024 $ 589.07 2024-07-25 10:00 COSTCO DEPOT 572 25,355.25 25,355.25 $ 589.07 2024 $ 589.07 2024-07-26 05:30 COSTCO DEPOT 571 26,208.82 26,208.82 $ 589.07 2024 $ 1,091.89 2024-07-26 06:00 COSTCO DEPOT 573 DRY 26,208.27 26,208.27 $ 1,091.89 2024 $ 5,825.17 2024-07-26 09:00 COSTCO DEPOT 76 22,063.53 22,063.53 $ 5,825.17 2024 $ 4,973.89 2024-07-26 09:35 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-07-26 11:00 COSTCO DEPOT 572 19,250.75 19,250.75 $ 589.07 2024 $ 1,091.89 2024-07-27 07:00 COSTCO DEPOT 573 DRY 22,384.88 22,384.88 $ 1,091.89 2024 $ 4,973.89 2024-07-30 08:30 COSTCO DEPOT 1034 DRY 28,493.96 28,493.96 $ 4,973.89 2024 $ 589.07 2024-07-30 10:00 COSTCO DEPOT 571 20,820.00 20,820.00 $ 589.07 2024 $ 589.07 2024-07-31 06:30 COSTCO DEPOT 571 26,625.70 26,625.70 $ 589.07 2024 $ 589.07 2024-07-31 11:00 COSTCO DEPOT 572 22,582.69 22,582.69 $ 589.07 2024 $ 589.07 2024-08-01 10:00 COSTCO DEPOT 572 18,390.25 18,390.25 $ 589.07 2024 $ 589.07 2024-08-02 06:30 COSTCO DEPOT 572 9,714.43 9,714.43 $ 589.07 2024 $ 1,091.89 2024-08-02 09:45 COSTCO DEPOT 574 WET 28,836.44 28,836.44 $ 1,091.89 2024 $ 589.07 2024-08-02 10:00 COSTCO DEPOT 572 28,836.44 28,836.44 $ 589.07 2024 $ 589.07 2024-08-02 10:00 COSTCO DEPOT 572 17,410.69 17,410.69 $ 589.07 2024 $ 1,091.89 2024-08-06 07:00 COSTCO DEPOT 573 DRY 24,484.70 24,484.70 $ 1,091.89 2024 $ 4,973.89 2024-08-06 10:35 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 1,091.89 2024-08-07 07:45 COSTCO DEPOT 574 WET 20,647.50 20,647.50 $ 1,091.89 2024 $ 1,091.89 2024-08-09 10:45 COSTCO DEPOT 574 WET 27,343.56 27,343.56 $ 1,091.89 2024 $ 4,973.89 2024-08-10 05:00 COSTCO DEPOT 1034 DRY 37,140.20 37,140.20 $ 4,973.89 2024 $ 1,091.89 2024-08-10 07:00 COSTCO DEPOT 573 DRY 24,138.63 24,138.63 $ 1,091.89 2024 $ 5,825.17 2024-08-10 07:15 COSTCO DEPOT 76 32,891.64 32,891.64 $ 5,825.17 2024 $ 589.07 2024-08-13 09:00 COSTCO DEPOT 572 16,640.00 16,640.00 $ 589.07 2024 $ 589.07 2024-08-14 06:00 COSTCO DEPOT 571 28,581.16 28,581.16 $ 589.07 2024 $ 1,091.89 2024-08-14 06:30 COSTCO DEPOT 573 DRY 21,950.83 21,950.83 $ 1,091.89 2024 $ 1,091.89 2024-08-14 08:45 COSTCO DEPOT 574 WET 16,640.00 16,640.00 $ 1,091.89 2024 $ 4,973.89 2024-08-14 10:35 COSTCO DEPOT 1035 WET 20,820.00 20,820.00 $ 4,973.89 2024 $ 589.07 2024-08-15 06:30 COSTCO DEPOT 572 14,753.56 14,753.56 $ 589.07 2024 $ 1,091.89 2024-08-15 10:45 COSTCO DEPOT 574 WET 21,559.36 21,559.36 $ 1,091.89 2024 $ 1,091.89 2024-08-16 10:00 COSTCO DEPOT 573 DRY 21,932.51 21,932.51 $ 1,091.89 2024 $ 589.07 2024-08-16 10:00 COSTCO DEPOT 572 21,894.63 21,894.63 $ 589.07 2024 $ 1,091.89 2024-08-19 06:30 COSTCO DEPOT 573 DRY 26,084.63 26,084.63 $ 1,091.89 2024 $ 1,091.89 2024-08-19 09:45 COSTCO DEPOT 574 WET 10,816.00 10,816.00 $ 1,091.89 2024 $ 589.07 2024-08-20 08:00 COSTCO DEPOT 572 18,304.00 18,304.00 $ 589.07 2024 $ 589.07 2024-08-20 10:00 COSTCO DEPOT 572 24,180.13 24,180.13 $ 589.07 2024 $ 589.07 2024-08-21 07:00 COSTCO DEPOT 571 34,360.20 34,360.20 $ 589.07 2024 $ 4,973.89 2024-08-22 07:00 COSTCO DEPOT 1034 DRY 19,751.22 19,751.22 $ 4,973.89 2024 $ 1,091.89 2024-08-22 07:45 COSTCO DEPOT 574 WET 19,314.69 19,314.69 $ 1,091.89 2024 $ 1,091.89 2024-08-22 08:15 COSTCO DEPOT 574 WET 17,461.44 17,461.44 $ 1,091.89 2024 $ 589.07 2024-08-23 07:30 COSTCO DEPOT 572 17,461.44 17,461.44 $ 589.07 2024 $ 4,973.89 2024-08-23 11:35 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 4,973.89 2024-08-25 23:59 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 1,091.89 2024-08-26 06:00 COSTCO DEPOT 573 DRY 27,729.14 27,729.14 $ 1,091.89 2024 $ 5,825.17 2024-08-26 08:00 COSTCO DEPOT 76 16,430.38 16,430.38 $ 5,825.17 2024 $ 1,091.89 2024-08-26 08:30 COSTCO DEPOT 573 DRY 32,050.26 32,050.26 $ 1,091.89 2024 $ 4,973.89 2024-08-27 06:00 COSTCO DEPOT 1034 DRY 17,745.44 17,745.44 $ 4,973.89 2024 $ 589.07 2024-08-27 07:30 COSTCO DEPOT 571 25,446.60 25,446.60 $ 589.07 2024 $ 589.07 2024-08-27 09:00 COSTCO DEPOT 572 27,401.26 27,401.26 $ 589.07 2024 $ 1,091.89 2024-08-28 10:30 COSTCO DEPOT 573 DRY 45,110.00 45,110.00 $ 1,091.89 2024 $ 5,825.17 2024-08-29 07:00 COSTCO DEPOT 76 25,299.01 25,299.01 $ 5,825.17 2024 $ 589.07 2024-08-29 08:30 COSTCO DEPOT 571 31,230.00 31,230.00 $ 589.07 2024 $ 1,091.89 2024-08-30 10:45 COSTCO DEPOT 574 WET 19,099.88 19,099.88 $ 1,091.89 2024 $ 4,973.89 2024-09-03 09:05 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 4,973.89 2024-09-03 10:00 COSTCO DEPOT 1034 DRY 39,813.84 39,813.84 $ 4,973.89 2024 $ 589.07 2024-09-05 06:00 COSTCO DEPOT 571 22,611.57 22,611.57 $ 589.07 2024 $ 1,091.89 2024-09-06 07:00 COSTCO DEPOT 573 DRY 32,459.75 32,459.75 $ 1,091.89 2024 $ 1,091.89 2024-09-06 08:15 COSTCO DEPOT 574 WET 25,455.54 25,455.54 $ 1,091.89 2024 $ 589.07 2024-09-06 09:00 COSTCO DEPOT 572 22,667.01 22,667.01 $ 589.07 2024 $ 4,973.89 2024-09-06 11:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 4,973.89 2024-09-07 08:00 COSTCO DEPOT 1034 DRY 32,994.03 32,994.03 $ 4,973.89 2024 $ 589.07 2024-09-10 08:30 COSTCO DEPOT 572 26,097.04 26,097.04 $ 589.07 2024 $ 589.07 2024-09-11 07:00 COSTCO DEPOT 571 26,130.09 26,130.09 $ 589.07 2024 $ 5,825.17 2024-09-11 08:45 COSTCO DEPOT 557 WET 24,290.00 24,290.00 $ 5,825.17 2024 $ 1,091.89 2024-09-11 10:30 COSTCO DEPOT 573 DRY 31,230.00 31,230.00 $ 1,091.89 2024 $ 1,091.89 2024-09-12 09:45 COSTCO DEPOT 574 WET 18,739.06 18,739.06 $ 1,091.89 2024 $ 589.07 2024-09-12 10:00 COSTCO DEPOT 572 14,691.38 14,691.38 $ 589.07 2024 $ 589.07 2024-09-13 09:00 COSTCO DEPOT 572 37,487.37 37,487.37 $ 589.07 2024 $ 1,091.89 2024-09-13 09:15 COSTCO DEPOT 574 WET 34,907.96 34,907.96 $ 1,091.89 2024 $ 5,825.17 2024-09-13 10:15 COSTCO DEPOT 557 WET 20,820.00 20,820.00 $ 5,825.17 2024 $ 4,973.89 2024-09-13 11:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-09-14 05:30 COSTCO DEPOT 571 19,085.00 19,085.00 $ 589.07 2024 $ 4,973.89 2024-09-16 06:00 COSTCO DEPOT 1034 DRY 21,972.77 21,972.77 $ 4,973.89 2024 $ 4,973.89 2024-09-16 06:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-09-16 06:30 COSTCO DEPOT 572 27,203.10 27,203.10 $ 589.07 2024 $ 1,091.89 2024-09-16 07:00 COSTCO DEPOT 573 DRY 33,175.15 33,175.15 $ 1,091.89 2024 $ 1,091.89 2024-09-16 10:15 COSTCO DEPOT 574 WET 23,892.80 23,892.80 $ 1,091.89 2024 $ 589.07 2024-09-17 06:00 COSTCO DEPOT 571 28,288.85 28,288.85 $ 589.07 2024 $ 5,825.17 2024-09-18 06:00 COSTCO DEPOT 76 20,090.38 20,090.38 $ 5,825.17 2024 $ 4,973.89 2024-09-18 06:00 COSTCO DEPOT 1034 DRY 25,220.28 25,220.28 $ 4,973.89 2024 $ 4,973.89 2024-09-18 10:35 COSTCO DEPOT 1035 WET 26,025.00 26,025.00 $ 4,973.89 2024 $ 4,973.89 2024-09-19 08:30 COSTCO DEPOT 1034 DRY 21,047.94 21,047.94 $ 4,973.89 2024 $ 589.07 2024-09-19 10:00 COSTCO DEPOT 572 9,503.25 9,503.25 $ 589.07 2024 $ 1,091.89 2024-09-19 10:15 COSTCO DEPOT 574 WET 9,557.81 9,557.81 $ 1,091.89 2024 $ 1,091.89 2024-09-20 06:45 COSTCO DEPOT 574 WET 34,581.27 34,581.27 $ 1,091.89 2024 $ 5,825.17 2024-09-20 09:00 COSTCO DEPOT 76 21,047.94 21,047.94 $ 5,825.17 2024 $ 589.07 2024-09-20 12:00 COSTCO DEPOT 571 20,356.69 20,356.69 $ 589.07 2024 $ 1,091.89 2024-09-21 05:30 COSTCO DEPOT 573 DRY 24,342.56 24,342.56 $ 1,091.89 2024 $ 5,825.17 2024-09-23 09:00 COSTCO DEPOT 76 30,739.46 30,739.46 $ 5,825.17 2024 $ 1,091.89 2024-09-25 07:45 COSTCO DEPOT 574 WET 25,219.98 25,219.98 $ 1,091.89 2024 $ 589.07 2024-09-25 10:00 COSTCO DEPOT 572 18,743.69 18,743.69 $ 589.07 2024 $ 4,973.89 2024-09-25 11:05 COSTCO DEPOT 1035 WET 41,640.00 41,640.00 $ 4,973.89 2024 $ 1,091.89 2024-09-26 06:30 COSTCO DEPOT 573 DRY 22,912.72 22,912.72 $ 1,091.89 2024 $ 589.07 2024-09-26 09:00 COSTCO DEPOT 572 10,119.20 10,119.20 $ 589.07 2024 $ 1,091.89 2024-09-27 06:30 COSTCO DEPOT 573 DRY 39,534.07 39,534.07 $ 1,091.89 2024 $ 589.07 2024-09-27 09:00 COSTCO DEPOT 572 22,174.25 22,174.25 $ 589.07 2024 $ 4,973.89 2024-09-28 06:00 COSTCO DEPOT 1034 DRY 21,047.94 21,047.94 $ 4,973.89 2024 $ 4,973.89 2024-09-28 07:00 COSTCO DEPOT 1034 DRY 26,763.15 26,763.15 $ 4,973.89 2024 $ 1,091.89 2024-10-03 06:30 COSTCO DEPOT 573 DRY 29,353.63 29,353.63 $ 1,091.89 2024 $ 589.07 2024-10-03 10:00 COSTCO DEPOT 572 34,025.25 34,025.25 $ 589.07 2024 $ 589.07 2024-10-04 09:00 COSTCO DEPOT 571 30,878.94 30,878.94 $ 589.07 2024 $ 4,973.89 2024-10-04 10:05 COSTCO DEPOT 1035 WET 24,290.00 24,290.00 $ 4,973.89 2024 $ 1,091.89 2024-10-04 10:45 COSTCO DEPOT 574 WET 31,485.75 31,485.75 $ 1,091.89 2024 $ 589.07 2024-10-05 06:00 COSTCO DEPOT 572 17,422.63 17,422.63 $ 589.07 2024 $ 589.07 2024-10-08 09:00 COSTCO DEPOT 572 26,734.07 26,734.07 $ 589.07 2024 $ 1,091.89 2024-10-08 09:15 COSTCO DEPOT 574 WET 21,162.50 21,162.50 $ 1,091.89 2024 $ 1,091.89 2024-10-08 09:15 COSTCO DEPOT 574 WET 29,460.07 29,460.07 $ 1,091.89 2024 $ 589.07 2024-10-09 10:00 COSTCO DEPOT 572 21,216.11 21,216.11 $ 589.07 2024 $ 589.07 2024-10-09 10:00 COSTCO DEPOT 572 26,925.88 26,925.88 $ 589.07 2024 $ 1,091.89 2024-10-10 05:00 COSTCO DEPOT 573 DRY 22,699.71 22,699.71 $ 1,091.89 2024 $ 589.07 2024-10-10 07:00 COSTCO DEPOT 571 21,583.33 21,583.33 $ 589.07 2024 $ 589.07 2024-10-10 07:30 COSTCO DEPOT 571 26,025.00 26,025.00 $ 589.07 2024 $ 1,091.89 2024-10-10 08:30 COSTCO DEPOT 573 DRY 41,640.00 41,640.00 $ 1,091.89 2024 $ 4,973.89 2024-10-11 08:00 COSTCO DEPOT 1034 DRY 34,334.92 34,334.92 $ 4,973.89 2024 $ 589.07 2024-10-11 10:00 COSTCO DEPOT 572 11,851.00 11,851.00 $ 589.07 2024 $ 589.07 2024-10-15 09:00 COSTCO DEPOT 572 14,390.50 14,390.50 $ 589.07 2024 $ 1,091.89 2024-10-15 10:00 COSTCO DEPOT 573 DRY 29,043.07 29,043.07 $ 1,091.89 2024 $ 589.07 2024-10-16 06:00 COSTCO DEPOT 571 34,984.57 34,984.57 $ 589.07 2024 $ 1,091.89 2024-10-17 10:45 COSTCO DEPOT QC 18,743.69 18,743.69 $ 1,091.89 2024 $ 589.07 2024-10-18 08:00 COSTCO DEPOT ON 18,743.69 18,743.69 $ 589.07 2024 $ 589.07 2024-10-18 10:00 COSTCO DEPOT 572 23,758.13 23,758.13 $ 589.07 2024 $ 1,091.89 2024-10-18 12:30 COSTCO DEPOT QC 26,025.00 26,025.00 $ 1,091.89 2024 $ 4,973.89 2024-10-19 06:30 COSTCO DEPOT 1034 DRY 26,758.63 26,758.63 $ 4,973.89 2024 $ 4,973.89 2024-10-19 06:30 COSTCO DEPOT 1034 DRY 25,793.63 25,793.63 $ 4,973.89 2024 $ 5,825.17 2024-10-19 07:15 COSTCO DEPOT 76 27,777.75 27,777.75 $ 5,825.17 2024 $ 589.07 2024-10-19 23:01 COSTCO DEPOT 571 38,596.25 38,596.25 $ 589.07 2024 $ 1,091.89 2024-10-21 11:15 COSTCO DEPOT QC 31,322.06 31,322.06 $ 1,091.89 2024 $ 589.07 2024-10-23 06:00 COSTCO DEPOT 571 14,332.44 14,332.44 $ 589.07 2024 $ 1,091.89 2024-10-24 06:30 COSTCO DEPOT QC 39,905.00 39,905.00 $ 1,091.89 2024 $ 589.07 2024-10-24 10:00 COSTCO DEPOT ON 27,757.68 27,757.68 $ 589.07 2024 $ 4,973.89 2024-10-24 12:05 COSTCO DEPOT 1035 WET 34,700.00 34,700.00 $ 4,973.89 2024 $ 4,973.89 2024-10-25 07:30 COSTCO DEPOT 1034 DRY 32,685.26 32,685.26 $ 4,973.89 2024 $ 4,973.89 2024-10-25 09:00 COSTCO DEPOT 1034 DRY 39,837.86 39,837.86 $ 4,973.89 2024 $ 589.07 2024-10-25 10:00 COSTCO DEPOT ON 23,758.13 23,758.13 $ 589.07 2024 $ 589.07 2024-10-25 10:00 COSTCO DEPOT ON 25,996.41 25,996.41 $ 589.07 2024 $ 1,091.89 2024-10-25 10:45 COSTCO DEPOT QC 25,560.25 25,560.25 $ 1,091.89 2024 $ 589.07 2024-10-25 23:01 COSTCO DEPOT 571 39,676.88 39,676.88 $ 589.07 2024 $ 589.07 2024-10-26 06:30 COSTCO DEPOT ON 23,758.13 23,758.13 $ 589.07 2024 $ 589.07 2024-10-26 06:30 COSTCO DEPOT ON 11,534.58 11,534.58 $ 589.07 2024 $ 1,091.89 2024-10-26 07:45 COSTCO DEPOT QC 14,494.93 14,494.93 $ 1,091.89 2024 $ 589.07 2024-10-28 10:00 COSTCO DEPOT ON 9,163.64 9,163.64 $ 589.07 2024 $ 1,091.89 2024-10-31 10:45 COSTCO DEPOT QC 22,174.25 22,174.25 $ 1,091.89 2024 $ 4,973.89 2024-10-31 11:05 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 1,091.89 2024-11-01 10:45 COSTCO DEPOT QC 32,905.94 32,905.94 $ 1,091.89 2024 $ 589.07 2024-11-01 11:00 COSTCO DEPOT ON 24,673.25 24,673.25 $ 589.07 2024 $ 5,825.17 2024-11-04 06:00 COSTCO DEPOT BC 19,396.46 19,396.46 $ 5,825.17 2024 $ 1,091.89 2024-11-04 23:01 COSTCO DEPOT 573 DRY 31,851.94 31,851.94 $ 1,091.89 2024 $ 1,091.89 2024-11-05 10:46 COSTCO DEPOT 574 WET 32,626.13 32,626.13 $ 1,091.89 2024 $ 4,973.89 2024-11-06 05:00 COSTCO DEPOT 1034 DRY 34,500.90 34,500.90 $ 4,973.89 2024 $ 589.07 2024-11-08 11:00 COSTCO DEPOT 572 12,034.27 12,034.27 $ 589.07 2024 $ 1,091.89 2024-11-11 10:15 COSTCO DEPOT QC 14,963.56 14,963.56 $ 1,091.89 2024 $ 1,091.89 2024-11-11 11:30 COSTCO DEPOT 573 DRY 32,294.76 32,294.76 $ 1,091.89 2024 $ 4,973.89 2024-11-12 10:35 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-11-13 11:00 COSTCO DEPOT 572 36,000.00 36,000.00 $ 589.07 2024 $ 1,091.89 2024-11-14 09:45 COSTCO DEPOT 574 WET 34,678.61 34,678.61 $ 1,091.89 2024 $ 589.07 2024-11-14 23:59 COSTCO DEPOT 572 25,423.25 25,423.25 $ 589.07 2024 $ 4,973.89 2024-11-15 07:00 COSTCO DEPOT 1034 DRY 23,195.93 23,195.93 $ 4,973.89 2024 $ 589.07 2024-11-15 07:00 COSTCO DEPOT 571 28,890.40 28,890.40 $ 589.07 2024 $ 1,091.89 2024-11-15 10:45 COSTCO DEPOT 574 WET 22,137.25 22,137.25 $ 1,091.89 2024 $ 589.07 2024-11-15 11:00 COSTCO DEPOT 572 22,137.25 22,137.25 $ 589.07 2024 $ 1,091.89 2024-11-15 12:30 COSTCO DEPOT 573 DRY 34,700.00 34,700.00 $ 1,091.89 2024 $ 589.07 2024-11-16 08:30 COSTCO DEPOT 571 26,571.26 26,571.26 $ 589.07 2024 $ 1,091.89 2024-11-18 23:59 COSTCO DEPOT 573 DRY 31,610.44 31,610.44 $ 1,091.89 2024 $ 589.07 2024-11-20 06:00 COSTCO DEPOT 571 22,555.00 22,555.00 $ 589.07 2024 $ 1,091.89 2024-11-20 08:30 COSTCO DEPOT 573 DRY 31,230.00 31,230.00 $ 1,091.89 2024 $ 589.07 2024-11-21 11:00 COSTCO DEPOT 572 18,072.91 18,072.91 $ 589.07 2024 $ 1,091.89 2024-11-22 10:30 COSTCO DEPOT 573 DRY 26,025.00 26,025.00 $ 1,091.89 2024 $ 1,091.89 2024-11-23 06:45 COSTCO DEPOT 574 WET 16,241.88 16,241.88 $ 1,091.89 2024 $ 589.07 2024-11-23 08:00 COSTCO DEPOT 572 14,079.00 14,079.00 $ 589.07 2024 $ 4,973.89 2024-11-25 12:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 1,091.89 2024-11-26 05:00 COSTCO DEPOT 573 DRY 31,442.39 31,442.39 $ 1,091.89 2024 $ 5,825.17 2024-11-26 08:45 COSTCO DEPOT 557 WET 20,820.00 20,820.00 $ 5,825.17 2024 $ 589.07 2024-11-27 09:00 COSTCO DEPOT 571 24,345.29 24,345.29 $ 589.07 2024 $ 589.07 2024-11-27 11:00 COSTCO DEPOT 572 17,366.69 17,366.69 $ 589.07 2024 $ 589.07 2024-11-29 08:00 COSTCO DEPOT 571 29,495.00 29,495.00 $ 589.07 2024 $ 1,091.89 2024-11-29 09:00 COSTCO DEPOT 573 DRY 26,025.00 26,025.00 $ 1,091.89 2024 $ 1,091.89 2024-11-29 10:45 COSTCO DEPOT 574 WET 25,116.35 25,116.35 $ 1,091.89 2024 $ 589.07 2024-11-29 11:00 COSTCO DEPOT 572 32,038.31 32,038.31 $ 589.07 2024 $ 4,973.89 2024-11-29 11:05 COSTCO DEPOT 1035 WET 34,700.00 34,700.00 $ 4,973.89 2024 $ 1,091.89 2024-12-03 09:30 COSTCO DEPOT 573 DRY 39,225.43 39,225.43 $ 1,091.89 2024 $ 4,973.89 2024-12-03 11:05 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2024 $ 589.07 2024-12-03 12:00 COSTCO DEPOT 572 31,258.13 31,258.13 $ 589.07 2024 $ 589.07 2024-12-03 12:00 COSTCO DEPOT 572 22,036.00 22,036.00 $ 589.07 2024 $ 589.07 2024-12-03 12:00 COSTCO DEPOT 572 22,036.00 22,036.00 $ 589.07 2024 $ 1,091.89 2024-12-04 09:45 COSTCO DEPOT 574 WET 14,166.00 14,166.00 $ 1,091.89 2024 $ 1,091.89 2024-12-04 10:15 COSTCO DEPOT 574 WET 22,174.25 22,174.25 $ 1,091.89 2024 $ 589.07 2024-12-05 12:00 COSTCO DEPOT 572 21,839.69 21,839.69 $ 589.07 2024 $ 1,091.89 2024-12-06 08:00 COSTCO DEPOT 573 DRY 43,120.61 43,120.61 $ 1,091.89 2024 $ 4,973.89 2024-12-06 11:05 COSTCO DEPOT 1035 WET 31,230.00 31,230.00 $ 4,973.89 2024 $ 589.07 2024-12-06 23:59 COSTCO DEPOT 572 32,151.79 32,151.79 $ 589.07 2024 $ 589.07 2024-12-07 04:00 COSTCO DEPOT 572 22,174.25 22,174.25 $ 589.07 2024 $ 1,091.89 2024-12-07 09:15 COSTCO DEPOT 574 WET 22,174.25 22,174.25 $ 1,091.89 2024 $ 1,091.89 2024-12-09 06:00 COSTCO DEPOT 573 DRY 25,360.00 25,360.00 $ 1,091.89 2024 $ 4,973.89 2024-12-09 06:05 COSTCO DEPOT 1035 WET 34,700.00 34,700.00 $ 4,973.89 2024 $ 1,091.89 2024-12-09 09:00 COSTCO DEPOT 573 DRY 44,815.00 44,815.00 $ 1,091.89 2024 $ 589.07 2024-12-10 06:00 COSTCO DEPOT 571 25,360.00 25,360.00 $ 589.07 2024 $ 589.07 2024-12-11 12:00 COSTCO DEPOT 572 25,786.00 25,786.00 $ 589.07 2024 $ 1,091.89 2024-12-12 09:45 COSTCO DEPOT 574 WET 24,723.88 24,723.88 $ 1,091.89 2024 $ 1,091.89 2024-12-12 10:30 COSTCO DEPOT 573 DRY 29,121.25 29,121.25 $ 1,091.89 2024 $ 589.07 2024-12-12 14:00 COSTCO DEPOT 571 20,820.00 20,820.00 $ 589.07 2024 $ 589.07 2024-12-13 11:00 COSTCO DEPOT 572 27,453.57 27,453.57 $ 589.07 2024 $ 589.07 2024-12-14 07:00 COSTCO DEPOT 571 20,820.00 20,820.00 $ 589.07 2024 $ 1,091.89 2024-12-14 09:30 COSTCO DEPOT 573 DRY 38,170.00 38,170.00 $ 1,091.89 2024 $ 4,973.89 2024-12-16 10:05 COSTCO DEPOT 1035 WET 34,700.00 34,700.00 $ 4,973.89 2024 $ 589.07 2024-12-17 05:00 COSTCO DEPOT 571 31,182.81 31,182.81 $ 589.07 2024 $ 1,091.89 2024-12-17 10:15 COSTCO DEPOT 574 WET 24,148.80 24,148.80 $ 1,091.89 2024 $ 589.07 2024-12-19 05:30 COSTCO DEPOT 571 29,495.00 29,495.00 $ 589.07 2024 $ 1,091.89 2024-12-19 08:00 COSTCO DEPOT 573 DRY 29,895.11 29,895.11 $ 1,091.89 2024 $ 4,973.89 2024-12-19 10:35 COSTCO DEPOT 1035 WET 41,640.00 41,640.00 $ 4,973.89 2024 $ 589.07 2024-12-19 12:00 COSTCO DEPOT 572 15,042.13 15,042.13 $ 589.07 2024 $ 5,825.17 2024-12-20 09:45 COSTCO DEPOT 557 WET 27,760.00 27,760.00 $ 5,825.17 2024 $ 1,091.89 2024-12-20 10:15 COSTCO DEPOT 574 WET 16,698.50 16,698.50 $ 1,091.89 2024 $ 589.07 2024-12-27 12:00 COSTCO DEPOT 572 15,812.39 15,812.39 $ 589.07 2024 $ 1,091.89 2024-12-28 06:45 COSTCO DEPOT 574 WET 16,570.01 16,570.01 $ 1,091.89 2024 $ 1,091.89 2024-12-28 08:30 COSTCO DEPOT 573 DRY 24,564.15 24,564.15 $ 1,091.89 2025 $ 589.07 2025-01-03 10:00 COSTCO DEPOT 572 10,935.80 10,935.80 $ 589.07 2025 $ 4,973.89 2025-01-06 05:30 COSTCO DEPOT 1034 DRY 29,001.00 29,001.00 $ 4,973.89 2025 $ 4,973.89 2025-01-06 07:00 COSTCO DEPOT 1034 DRY 29,477.92 29,477.92 $ 4,973.89 2025 $ 1,091.89 2025-01-06 11:30 COSTCO DEPOT 573 DRY 13,880.00 13,880.00 $ 1,091.89 2025 $ 5,835.07 2025-01-06 12:00 COSTCO DEPOT 76 40,523.44 40,523.44 $ 5,835.07 2025 $ 4,973.89 2025-01-10 11:05 COSTCO DEPOT 1035 WET 20,820.00 20,820.00 $ 4,973.89 2025 $ 4,973.89 2025-01-13 09:35 COSTCO DEPOT 1035 WET 27,760.00 27,760.00 $ 4,973.89 2025 $ 1,091.89 2025-01-13 10:15 COSTCO DEPOT 574 WET 15,687.43 15,687.43 $ 1,091.89 2025 $ 589.07 2025-01-14 05:00 COSTCO DEPOT 571 32,266.65 32,266.65 $ 589.07 2025 $ 4,973.89 2025-01-17 07:30 COSTCO DEPOT 1034 DRY 15,482.54 15,482.54 $ 4,973.89 2025 $ 589.07 2025-01-17 11:00 COSTCO DEPOT 572 14,304.21 14,304.21 $ 589.07 2025 $ 1,091.89 2025-01-18 06:00 COSTCO DEPOT 573 DRY 25,275.19 25,275.19 $ 1,091.89 2025 $ 589.07 2025-01-20 05:00 COSTCO DEPOT 571 45,253.89 45,253.89 $ 589.07 2025 $ 589.07 2025-01-20 05:30 COSTCO DEPOT 571 43,650.00 43,650.00 $ 589.07 2025 $ 1,091.89 2025-01-20 08:00 COSTCO DEPOT 573 DRY 43,650.00 43,650.00 $ 1,091.89 2025 $ 1,091.89 2025-01-20 08:30 COSTCO DEPOT 573 DRY 43,650.00 43,650.00 $ 1,091.89 2025 $ 589.07 2025-01-24 09:00 COSTCO DEPOT 572 36,960.62 36,960.62 $ 589.07 2025 $ 1,091.89 2025-01-24 10:15 COSTCO DEPOT 574 WET 33,000.55 33,000.55 $ 1,091.89 2025 $ 589.07 2025-01-24 12:00 COSTCO DEPOT 572 7,139.80 7,139.80 $ 589.07 2025 $ 1,091.89 2025-01-27 06:30 COSTCO DEPOT 573 DRY 6,950.51 6,950.51 $ 1,091.89 Hi GVallentgoed ,
Try using the following formula:
sumx ptl cost = CALCULATE(SUMX(VALUES('Data'[Destination Name]),Data[Ptl Cost]),ALLSELECTED(Data))Sumx Savings = CALCULATE(SUMX(VALUES('Data'[Destination Name]),'Data'[Savings]),ALLSELECTED('Data'))sumx 2025 = CALCULATE(SUMX(VALUES('Data'[Destination Name]),Data[2025 Cost]),ALLSELECTED(data))Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ahh I was missing the "Values" criteria! Thanks!
