hello,
hope everyone is ok.
I have a set of data (example below) where in I want to get the monthly average of the 'Amount1' per location. Can someone show me how to do this? thanks a lot. appreciate all your help.
LOCATION | BUSINESS_DATE | AMOUNT1 | CashMonth |
AAA | 01Sep2021 | $91,140.35 | Sep2021 |
AAA | 02Sep2021 | $101,122.85 | Sep2021 |
AAA | 03Sep2021 | $116,158.25 | Sep2021 |
AAA | 04Sep2021 | $124,706.50 | Sep2021 |
AAA | 05Sep2021 | $123,713.40 | Sep2021 |
AAA | 06Sep2021 | $130,878.40 | Sep2021 |
AAA | 07Sep2021 | $138,482.65 | Sep2021 |
AAA | 08Sep2021 | $84,782.20 | Sep2021 |
AAA | 09Sep2021 | $74,250.60 | Sep2021 |
AAA | 10Sep2021 | $85,445.00 | Sep2021 |
AAA | 11Sep2021 | $86,982.90 | Sep2021 |
AAA | 12Sep2021 | $98,150.75 | Sep2021 |
AAA | 13Sep2021 | $89,718.35 | Sep2021 |
AAA | 14Sep2021 | $73,539.30 | Sep2021 |
AAA | 15Sep2021 | $78,896.15 | Sep2021 |
AAA | 16Sep2021 | $71,118.05 | Sep2021 |
AAA | 17Sep2021 | $90,077.30 | Sep2021 |
AAA | 18Sep2021 | $87,571.50 | Sep2021 |
AAA | 19Sep2021 | $81,179.00 | Sep2021 |
AAA | 20Sep2021 | $90,763.05 | Sep2021 |
AAA | 21Sep2021 | $88,174.65 | Sep2021 |
AAA | 22Sep2021 | $79,190.00 | Sep2021 |
AAA | 23Sep2021 | $89,612.80 | Sep2021 |
AAA | 24Sep2021 | $83,126.50 | Sep2021 |
AAA | 25Sep2021 | $79,973.05 | Sep2021 |
AAA | 26Sep2021 | $91,316.45 | Sep2021 |
AAA | 27Sep2021 | $89,777.40 | Sep2021 |
AAA | 28Sep2021 | $81,364.15 | Sep2021 |
AAA | 29Sep2021 | $83,376.05 | Sep2021 |
AAA | 30Sep2021 | $73,829.15 | Sep2021 |
AAA | 01Oct2021 | $72,510.00 | Oct2021 |
AAA | 02Oct2021 | $78,184.25 | Oct2021 |
AAA | 03Oct2021 | $89,072.40 | Oct2021 |
AAA | 04Oct2021 | $107,678.85 | Oct2021 |
AAA | 05Oct2021 | $117,100.75 | Oct2021 |
AAA | 06Oct2021 | $74,819.30 | Oct2021 |
AAA | 07Oct2021 | $81,169.10 | Oct2021 |
AAA | 08Oct2021 | $77,686.90 | Oct2021 |
AAA | 09Oct2021 | $93,829.85 | Oct2021 |
AAA | 10Oct2021 | $85,463.95 | Oct2021 |
AAA | 11Oct2021 | $88,054.25 | Oct2021 |
AAA | 12Oct2021 | $59,951.80 | Oct2021 |
AAA | 13Oct2021 | $65,128.45 | Oct2021 |
AAA | 14Oct2021 | $67,994.05 | Oct2021 |
AAA | 15Oct2021 | $56,053.75 | Oct2021 |
AAA | 16Oct2021 | $67,828.15 | Oct2021 |
AAA | 17Oct2021 | $65,604.85 | Oct2021 |
AAA | 18Oct2021 | $75,441.15 | Oct2021 |
AAA | 19Oct2021 | $76,151.95 | Oct2021 |
AAA | 20Oct2021 | $75,808.75 | Oct2021 |
AAA | 21Oct2021 | $69,402.45 | Oct2021 |
AAA | 22Oct2021 | $84,123.10 | Oct2021 |
AAA | 23Oct2021 | $62,867.90 | Oct2021 |
AAA | 24Oct2021 | $67,478.45 | Oct2021 |
AAA | 25Oct2021 | $76,752.55 | Oct2021 |
AAA | 26Oct2021 | $91,795.05 | Oct2021 |
AAA | 27Oct2021 | $86,566.00 | Oct2021 |
AAA | 28Oct2021 | $87,742.05 | Oct2021 |
AAA | 29Oct2021 | $74,263.60 | Oct2021 |
AAA | 30Oct2021 | $77,305.65 | Oct2021 |
AAA | 31Oct2021 | $68,791.00 | Oct2021 |
AAA | 01Nov2021 | $74,254.45 | Nov2021 |
AAA | 02Nov2021 | $73,806.35 | Nov2021 |
AAA | 03Nov2021 | $77,812.05 | Nov2021 |
AAA | 04Nov2021 | $74,526.05 | Nov2021 |
AAA | 05Nov2021 | $92,869.90 | Nov2021 |
AAA | 06Nov2021 | $96,516.00 | Nov2021 |
AAA | 07Nov2021 | $91,670.35 | Nov2021 |
AAA | 08Nov2021 | $117,308.75 | Nov2021 |
AAA | 09Nov2021 | $76,280.80 | Nov2021 |
AAA | 10Nov2021 | $84,246.60 | Nov2021 |
AAA | 11Nov2021 | $76,044.30 | Nov2021 |
AAA | 12Nov2021 | $69,175.15 | Nov2021 |
AAA | 13Nov2021 | $64,876.75 | Nov2021 |
AAA | 14Nov2021 | $73,236.45 | Nov2021 |
AAA | 15Nov2021 | $76,268.10 | Nov2021 |
AAA | 16Nov2021 | $77,970.80 | Nov2021 |
AAA | 17Nov2021 | $73,450.05 | Nov2021 |
AAA | 18Nov2021 | $70,909.65 | Nov2021 |
AAA | 19Nov2021 | $67,336.00 | Nov2021 |
AAA | 20Nov2021 | $62,963.85 | Nov2021 |
AAA | 21Nov2021 | $63,808.25 | Nov2021 |
AAA | 22Nov2021 | $80,681.35 | Nov2021 |
AAA | 23Nov2021 | $77,624.75 | Nov2021 |
AAA | 24Nov2021 | $80,876.90 | Nov2021 |
AAA | 25Nov2021 | $95,211.10 | Nov2021 |
AAA | 26Nov2021 | $95,913.75 | Nov2021 |
AAA | 27Nov2021 | $99,118.35 | Nov2021 |
AAA | 28Nov2021 | $78,633.15 | Nov2021 |
AAA | 29Nov2021 | $71,872.50 | Nov2021 |
AAA | 30Nov2021 | $81,666.35 | Nov2021 |
AAA | 01Dec2021 | $77,491.45 | Dec2021 |
AAA | 02Dec2021 | $81,428.05 | Dec2021 |
AAA | 03Dec2021 | $84,504.80 | Dec2021 |
AAA | 04Dec2021 | $70,384.30 | Dec2021 |
AAA | 05Dec2021 | $83,318.90 | Dec2021 |
AAA | 06Dec2021 | $101,017.30 | Dec2021 |
AAA | 07Dec2021 | $103,847.55 | Dec2021 |
AAA | 08Dec2021 | $93,092.55 | Dec2021 |
AAA | 09Dec2021 | $89,640.40 | Dec2021 |
AAA | 10Dec2021 | $111,540.00 | Dec2021 |
AAA | 11Dec2021 | $84,502.60 | Dec2021 |
AAA | 12Dec2021 | $78,029.40 | Dec2021 |
AAA | 13Dec2021 | $75,507.05 | Dec2021 |
AAA | 14Dec2021 | $62,777.05 | Dec2021 |
AAA | 15Dec2021 | $70,721.30 | Dec2021 |
AAA | 16Dec2021 | $72,380.70 | Dec2021 |
AAA | 17Dec2021 | $84,370.70 | Dec2021 |
AAA | 18Dec2021 | $90,914.45 | Dec2021 |
AAA | 19Dec2021 | $89,276.70 | Dec2021 |
AAA | 20Dec2021 | $102,430.50 | Dec2021 |
AAA | 21Dec2021 | $110,538.10 | Dec2021 |
AAA | 22Dec2021 | $109,668.15 | Dec2021 |
AAA | 23Dec2021 | $87,338.80 | Dec2021 |
AAA | 24Dec2021 | $100,998.00 | Dec2021 |
AAA | 25Dec2021 | $71,141.95 | Dec2021 |
AAA | 26Dec2021 | $71,141.95 | Dec2021 |
AAA | 27Dec2021 | $54,629.65 | Dec2021 |
AAA | 28Dec2021 | $50,730.65 | Dec2021 |
AAA | 29Dec2021 | $60,785.90 | Dec2021 |
AAA | 30Dec2021 | $74,551.40 | Dec2021 |
AAA | 31Dec2021 | $76,219.30 | Dec2021 |
AAA | 01Jan2022 | $65,847.60 | Jan2022 |
AAA | 02Jan2022 | $65,847.60 | Jan2022 |
AAA | 03Jan2022 | $80,653.50 | Jan2022 |
AAA | 04Jan2022 | $76,941.15 | Jan2022 |
AAA | 05Jan2022 | $111,099.40 | Jan2022 |
AAA | 06Jan2022 | $81,192.65 | Jan2022 |
AAA | 07Jan2022 | $80,516.50 | Jan2022 |
AAA | 08Jan2022 | $77,600.25 | Jan2022 |
AAA | 09Jan2022 | $77,600.25 | Jan2022 |
AAA | 10Jan2022 | $77,600.25 | Jan2022 |
AAA | 11Jan2022 | $84,850.80 | Jan2022 |
AAA | 12Jan2022 | $78,523.75 | Jan2022 |
AAA | 13Jan2022 | $75,385.15 | Jan2022 |
AAA | 14Jan2022 | $78,596.65 | Jan2022 |
AAA | 15Jan2022 | $73,639.90 | Jan2022 |
AAA | 16Jan2022 | $79,540.15 | Jan2022 |
AAA | 17Jan2022 | $81,294.05 | Jan2022 |
AAA | 18Jan2022 | $83,151.05 | Jan2022 |
AAA | 19Jan2022 | $74,774.00 | Jan2022 |
AAA | 20Jan2022 | $73,760.15 | Jan2022 |
AAA | 21Jan2022 | $81,622.25 | Jan2022 |
AAA | 22Jan2022 | $79,024.50 | Jan2022 |
AAA | 23Jan2022 | $62,844.40 | Jan2022 |
AAA | 24Jan2022 | $64,096.65 | Jan2022 |
AAA | 25Jan2022 | $55,287.40 | Jan2022 |
AAA | 26Jan2022 | $50,271.00 | Jan2022 |
AAA | 27Jan2022 | $52,325.70 | Jan2022 |
AAA | 28Jan2022 | $63,229.60 | Jan2022 |
AAA | 29Jan2022 | $51,056.20 | Jan2022 |
AAA | 30Jan2022 | $67,521.80 | Jan2022 |
AAA | 31Jan2022 | $77,819.60 | Jan2022 |
AAA | 01Feb2022 | $112,340.40 | Feb2022 |
AAA | 02Feb2022 | $123,661.05 | Feb2022 |
AAA | 03Feb2022 | $87,726.10 | Feb2022 |
AAA | 04Feb2022 | $79,969.75 | Feb2022 |
AAA | 05Feb2022 | $65,836.65 | Feb2022 |
AAA | 06Feb2022 | $82,062.20 | Feb2022 |
AAA | 07Feb2022 | $80,960.95 | Feb2022 |
AAA | 08Feb2022 | $103,023.00 | Feb2022 |
AAA | 09Feb2022 | $99,102.45 | Feb2022 |
AAA | 10Feb2022 | $101,213.65 | Feb2022 |
AAA | 11Feb2022 | $70,927.35 | Feb2022 |
AAA | 12Feb2022 | $70,051.60 | Feb2022 |
AAA | 13Feb2022 | $73,776.90 | Feb2022 |
AAA | 14Feb2022 | $64,986.40 | Feb2022 |
AAA | 15Feb2022 | $51,144.80 | Feb2022 |
AAA | 16Feb2022 | $57,252.30 | Feb2022 |
AAA | 17Feb2022 | $58,981.15 | Feb2022 |
AAA | 18Feb2022 | $60,601.05 | Feb2022 |
AAA | 19Feb2022 | $63,281.20 | Feb2022 |
AAA | 20Feb2022 | $65,883.90 | Feb2022 |
AAA | 21Feb2022 | $65,352.80 | Feb2022 |
AAA | 22Feb2022 | $71,518.65 | Feb2022 |
AAA | 23Feb2022 | $80,189.25 | Feb2022 |
AAA | 24Feb2022 | $54,136.65 | Feb2022 |
AAA | 25Feb2022 | $45,141.05 | Feb2022 |
AAA | 26Feb2022 | $44,649.40 | Feb2022 |
AAA | 27Feb2022 | $54,315.10 | Feb2022 |
AAA | 28Feb2022 | $74,475.65 | Feb2022 |
AAA | 01Mar2022 | $89,881.60 | Mar2022 |
AAA | 02Mar2022 | $130,249.45 | Mar2022 |
AAA | 03Mar2022 | $78,708.90 | Mar2022 |
AAA | 04Mar2022 | $68,605.45 | Mar2022 |
AAA | 05Mar2022 | $72,113.90 | Mar2022 |
AAA | 06Mar2022 | $73,016.10 | Mar2022 |
AAA | 07Mar2022 | $76,390.80 | Mar2022 |
AAA | 08Mar2022 | $76,389.75 | Mar2022 |
AAA | 09Mar2022 | $95,266.60 | Mar2022 |
AAA | 10Mar2022 | $98,947.75 | Mar2022 |
AAA | 11Mar2022 | $103,986.95 | Mar2022 |
AAA | 12Mar2022 | $99,888.45 | Mar2022 |
AAA | 13Mar2022 | $96,156.35 | Mar2022 |
AAA | 14Mar2022 | $106,117.95 | Mar2022 |
AAA | 15Mar2022 | $80,062.50 | Mar2022 |
AAA | 16Mar2022 | $60,511.70 | Mar2022 |
AAA | 17Mar2022 | $58,835.40 | Mar2022 |
AAA | 18Mar2022 | $75,016.80 | Mar2022 |
AAA | 19Mar2022 | $78,192.00 | Mar2022 |
AAA | 20Mar2022 | $64,519.30 | Mar2022 |
AAA | 21Mar2022 | $61,292.50 | Mar2022 |
AAA | 22Mar2022 | $84,973.70 | Mar2022 |
AAA | 23Mar2022 | $99,441.55 | Mar2022 |
AAA | 24Mar2022 | $87,129.70 | Mar2022 |
AAA | 25Mar2022 | $118,322.40 | Mar2022 |
AAA | 26Mar2022 | $69,199.05 | Mar2022 |
AAA | 27Mar2022 | $68,600.00 | Mar2022 |
AAA | 28Mar2022 | $69,807.15 | Mar2022 |
AAA | 29Mar2022 | $80,550.70 | Mar2022 |
AAA | 30Mar2022 | $83,232.95 | Mar2022 |
AAA | 31Mar2022 | $85,338.60 | Mar2022 |
AAA | 01Apr2022 | $115,659.90 | Apr2022 |
AAA | 02Apr2022 | $85,029.50 | Apr2022 |
AAA | 03Apr2022 | $94,602.60 | Apr2022 |
AAA | 04Apr2022 | $101,446.50 | Apr2022 |
AAA | 05Apr2022 | $92,878.95 | Apr2022 |
AAA | 06Apr2022 | $109,717.60 | Apr2022 |
AAA | 07Apr2022 | $76,844.10 | Apr2022 |
AAA | 08Apr2022 | $79,244.00 | Apr2022 |
AAA | 09Apr2022 | $86,896.30 | Apr2022 |
AAA | 10Apr2022 | $84,507.25 | Apr2022 |
AAA | 11Apr2022 | $104,699.20 | Apr2022 |
AAA | 12Apr2022 | $89,492.65 | Apr2022 |
AAA | 13Apr2022 | $81,633.45 | Apr2022 |
AAA | 14Apr2022 | $87,485.85 | Apr2022 |
AAA | 15Apr2022 | $72,020.40 | Apr2022 |
AAA | 16Apr2022 | $55,650.20 | Apr2022 |
AAA | 17Apr2022 | $41,749.35 | Apr2022 |
AAA | 18Apr2022 | $48,712.60 | Apr2022 |
AAA | 19Apr2022 | $52,302.75 | Apr2022 |
AAA | 20Apr2022 | $76,745.95 | Apr2022 |
AAA | 21Apr2022 | $55,608.00 | Apr2022 |
AAA | 22Apr2022 | $78,883.90 | Apr2022 |
AAA | 23Apr2022 | $70,447.95 | Apr2022 |
AAA | 24Apr2022 | $67,666.05 | Apr2022 |
AAA | 25Apr2022 | $71,078.45 | Apr2022 |
AAA | 26Apr2022 | $78,636.95 | Apr2022 |
AAA | 27Apr2022 | $80,057.10 | Apr2022 |
AAA | 28Apr2022 | $76,650.35 | Apr2022 |
AAA | 29Apr2022 | $79,982.70 | Apr2022 |
AAA | 30Apr2022 | $53,268.65 | Apr2022 |
AAA | 01May2022 | $56,935.70 | May2022 |
AAA | 02May2022 | $61,909.50 | May2022 |
AAA | 03May2022 | $76,157.95 | May2022 |
AAA | 04May2022 | $72,207.25 | May2022 |
AAA | 05May2022 | $75,737.20 | May2022 |
AAA | 06May2022 | $85,824.30 | May2022 |
AAA | 07May2022 | $92,666.10 | May2022 |
AAA | 08May2022 | $79,799.40 | May2022 |
AAA | 09May2022 | $74,724.50 | May2022 |
AAA | 10May2022 | $81,461.05 | May2022 |
AAA | 11May2022 | $83,676.50 | May2022 |
AAA | 12May2022 | $65,865.50 | May2022 |
AAA | 13May2022 | $65,964.30 | May2022 |
AAA | 14May2022 | $71,632.00 | May2022 |
AAA | 15May2022 | $82,496.95 | May2022 |
AAA | 16May2022 | $73,224.70 | May2022 |
AAA | 17May2022 | $67,100.30 | May2022 |
AAA | 18May2022 | $56,463.15 | May2022 |
AAA | 19May2022 | $74,114.25 | May2022 |
AAA | 20May2022 | $63,914.90 | May2022 |
AAA | 21May2022 | $53,015.85 | May2022 |
AAA | 22May2022 | $47,874.10 | May2022 |
AAA | 23May2022 | $57,221.10 | May2022 |
AAA | 24May2022 | $69,482.95 | May2022 |
AAA | 25May2022 | $89,774.85 | May2022 |
AAA | 26May2022 | $112,377.75 | May2022 |
AAA | 27May2022 | $136,554.70 | May2022 |
AAA | 28May2022 | $131,284.40 | May2022 |
AAA | 29May2022 | $109,643.60 | May2022 |
AAA | 30May2022 | $102,412.80 | May2022 |
AAA | 31May2022 | $74,342.80 | May2022 |
AAA | 01Jun2022 | $88,843.35 | Jun2022 |
AAA | 02Jun2022 | $101,410.20 | Jun2022 |
AAA | 03Jun2022 | $129,595.05 | Jun2022 |
AAA | 04Jun2022 | $70,519.30 | Jun2022 |
AAA | 05Jun2022 | $84,250.45 | Jun2022 |
AAA | 06Jun2022 | $96,546.85 | Jun2022 |
AAA | 07Jun2022 | $135,078.90 | Jun2022 |
AAA | 08Jun2022 | $91,372.00 | Jun2022 |
AAA | 09Jun2022 | $80,652.85 | Jun2022 |
AAA | 10Jun2022 | $88,602.15 | Jun2022 |
AAA | 11Jun2022 | $57,481.80 | Jun2022 |
AAA | 12Jun2022 | $56,613.30 | Jun2022 |
AAA | 13Jun2022 | $69,428.70 | Jun2022 |
AAA | 14Jun2022 | $63,676.80 | Jun2022 |
AAA | 15Jun2022 | $57,354.20 | Jun2022 |
AAA | 16Jun2022 | $60,512.35 | Jun2022 |
AAA | 17Jun2022 | $61,372.10 | Jun2022 |
AAA | 18Jun2022 | $79,567.90 | Jun2022 |
AAA | 19Jun2022 | $73,018.50 | Jun2022 |
AAA | 20Jun2022 | $81,104.20 | Jun2022 |
AAA | 21Jun2022 | $82,768.05 | Jun2022 |
AAA | 22Jun2022 | $71,030.60 | Jun2022 |
AAA | 23Jun2022 | $83,082.30 | Jun2022 |
AAA | 24Jun2022 | $86,547.45 | Jun2022 |
AAA | 25Jun2022 | $80,398.60 | Jun2022 |
AAA | 26Jun2022 | $79,207.30 | Jun2022 |
AAA | 27Jun2022 | $97,260.65 | Jun2022 |
AAA | 28Jun2022 | $86,863.70 | Jun2022 |
AAA | 29Jun2022 | $73,591.90 | Jun2022 |
AAA | 30Jun2022 | $61,861.65 | Jun2022 |
AAA | 01Jul2022 | $54,613.50 | Jul2022 |
AAA | 02Jul2022 | $59,235.80 | Jul2022 |
AAA | 03Jul2022 | $55,021.95 | Jul2022 |
AAA | 04Jul2022 | $72,278.90 | Jul2022 |
AAA | 05Jul2022 | $81,393.75 | Jul2022 |
AAA | 06Jul2022 | $87,176.25 | Jul2022 |
AAA | 07Jul2022 | $70,679.85 | Jul2022 |
AAA | 08Jul2022 | $73,634.55 | Jul2022 |
AAA | 09Jul2022 | $70,098.05 | Jul2022 |
AAA | 10Jul2022 | $71,694.15 | Jul2022 |
AAA | 11Jul2022 | $87,671.15 | Jul2022 |
AAA | 12Jul2022 | $90,714.95 | Jul2022 |
AAA | 13Jul2022 | $83,223.65 | Jul2022 |
AAA | 14Jul2022 | $97,430.30 | Jul2022 |
AAA | 15Jul2022 | $95,317.20 | Jul2022 |
AAA | 16Jul2022 | $78,900.45 | Jul2022 |
AAA | 17Jul2022 | $68,554.45 | Jul2022 |
AAA | 18Jul2022 | $51,628.80 | Jul2022 |
AAA | 19Jul2022 | $61,245.35 | Jul2022 |
AAA | 20Jul2022 | $62,920.35 | Jul2022 |
AAA | 21Jul2022 | $77,137.25 | Jul2022 |
AAA | 22Jul2022 | $93,629.65 | Jul2022 |
AAA | 23Jul2022 | $79,031.35 | Jul2022 |
AAA | 24Jul2022 | $75,977.95 | Jul2022 |
AAA | 25Jul2022 | $75,294.45 | Jul2022 |
AAA | 26Jul2022 | $68,417.55 | Jul2022 |
AAA | 27Jul2022 | $55,269.90 | Jul2022 |
AAA | 28Jul2022 | $56,787.75 | Jul2022 |
AAA | 29Jul2022 | $78,588.50 | Jul2022 |
AAA | 30Jul2022 | $69,727.35 | Jul2022 |
AAA | 31Jul2022 | $75,411.45 | Jul2022 |
AAA | 01Aug2022 | $86,157.10 | Aug2022 |
AAA | 02Aug2022 | $97,647.90 | Aug2022 |
AAA | 03Aug2022 | $101,916.05 | Aug2022 |
AAA | 04Aug2022 | $106,273.85 | Aug2022 |
AAA | 05Aug2022 | $92,401.80 | Aug2022 |
AAA | 06Aug2022 | $81,833.70 | Aug2022 |
AAA | 07Aug2022 | $60,463.00 | Aug2022 |
AAA | 08Aug2022 | $72,056.30 | Aug2022 |
AAA | 09Aug2022 | $69,386.55 | Aug2022 |
AAA | 10Aug2022 | $70,302.80 | Aug2022 |
AAA | 11Aug2022 | $87,321.05 | Aug2022 |
AAA | 12Aug2022 | $89,974.90 | Aug2022 |
AAA | 13Aug2022 | $91,447.55 | Aug2022 |
AAA | 14Aug2022 | $99,865.95 | Aug2022 |
AAA | 15Aug2022 | $91,602.45 | Aug2022 |
AAA | 16Aug2022 | $85,009.50 | Aug2022 |
AAA | 17Aug2022 | $68,224.60 | Aug2022 |
AAA | 18Aug2022 | $75,695.85 | Aug2022 |
AAA | 19Aug2022 | $78,005.90 | Aug2022 |
AAA | 20Aug2022 | $75,179.30 | Aug2022 |
AAA | 21Aug2022 | $73,191.45 | Aug2022 |
AAA | 22Aug2022 | $72,284.70 | Aug2022 |
AAA | 23Aug2022 | $75,595.40 | Aug2022 |
AAA | 24Aug2022 | $80,295.45 | Aug2022 |
AAA | 25Aug2022 | $83,414.85 | Aug2022 |
AAA | 26Aug2022 | $78,761.75 | Aug2022 |
AAA | 27Aug2022 | $68,089.30 | Aug2022 |
AAA | 28Aug2022 | $61,747.30 | Aug2022 |
AAA | 29Aug2022 | $61,570.70 | Aug2022 |
AAA | 30Aug2022 | $72,426.70 | Aug2022 |
AAA | 31Aug2022 | $69,931.30 | Aug2022 |
AAA | 01Sep2022 | $79,049.15 | Sep2022 |
AAA | 02Sep2022 | $78,662.75 | Sep2022 |
AAA | 03Sep2022 | $46,992.90 | Sep2022 |
AAA | 04Sep2022 | $52,707.80 | Sep2022 |
AAA | 05Sep2022 | $54,264.40 | Sep2022 |
AAA | 06Sep2022 | $60,299.65 | Sep2022 |
AAA | 07Sep2022 | $54,755.80 | Sep2022 |
AAA | 08Sep2022 | $55,456.90 | Sep2022 |
AAA | 09Sep2022 | $64,330.85 | Sep2022 |
AAA | 10Sep2022 | $59,825.70 | Sep2022 |
AAA | 11Sep2022 | $58,009.60 | Sep2022 |
AAA | 12Sep2022 | $51,500.75 | Sep2022 |
AAA | 13Sep2022 | $61,554.15 | Sep2022 |
AAA | 14Sep2022 | $83,614.60 | Sep2022 |
AAA | 15Sep2022 | $84,225.10 | Sep2022 |
AAA | 16Sep2022 | $112,331.65 | Sep2022 |
AAA | 17Sep2022 | $104,455.30 | Sep2022 |
AAA | 18Sep2022 | $95,453.65 | Sep2022 |
AAA | 19Sep2022 | $103,615.75 | Sep2022 |
AAA | 20Sep2022 | $93,636.55 | Sep2022 |
AAA | 21Sep2022 | $79,875.45 | Sep2022 |
AAA | 22Sep2022 | $76,249.25 | Sep2022 |
AAA | 23Sep2022 | $61,497.00 | Sep2022 |
AAA | 24Sep2022 | $46,077.35 | Sep2022 |
AAA | 25Sep2022 | $42,008.10 | Sep2022 |
AAA | 26Sep2022 | $35,932.45 | Sep2022 |
AAA | 27Sep2022 | $45,705.15 | Sep2022 |
AAA | 28Sep2022 | $75,174.95 | Sep2022 |
AAA | 29Sep2022 | $79,058.25 | Sep2022 |
AAA | 30Sep2022 | $92,473.10 | Sep2022 |
BBB | 01Sep2021 | $76,839.00 | Sep2021 |
BBB | 02Sep2021 | $53,733.15 | Sep2021 |
BBB | 03Sep2021 | $49,784.25 | Sep2021 |
BBB | 04Sep2021 | $40,287.00 | Sep2021 |
BBB | 05Sep2021 | $37,651.65 | Sep2021 |
BBB | 06Sep2021 | $35,251.30 | Sep2021 |
BBB | 07Sep2021 | $41,763.00 | Sep2021 |
BBB | 08Sep2021 | $43,213.25 | Sep2021 |
BBB | 09Sep2021 | $63,803.95 | Sep2021 |
BBB | 10Sep2021 | $84,496.90 | Sep2021 |
BBB | 11Sep2021 | $59,507.20 | Sep2021 |
BBB | 12Sep2021 | $54,903.55 | Sep2021 |
BBB | 13Sep2021 | $57,056.25 | Sep2021 |
BBB | 14Sep2021 | $75,688.25 | Sep2021 |
BBB | 15Sep2021 | $67,069.20 | Sep2021 |
BBB | 16Sep2021 | $53,027.10 | Sep2021 |
BBB | 17Sep2021 | $58,699.15 | Sep2021 |
BBB | 18Sep2021 | $90,295.20 | Sep2021 |
BBB | 19Sep2021 | $96,653.90 | Sep2021 |
BBB | 20Sep2021 | $94,024.35 | Sep2021 |
BBB | 21Sep2021 | $89,658.20 | Sep2021 |
BBB | 22Sep2021 | $121,080.80 | Sep2021 |
BBB | 23Sep2021 | $90,829.65 | Sep2021 |
BBB | 24Sep2021 | $90,829.65 | Sep2021 |
BBB | 25Sep2021 | $81,636.00 | Sep2021 |
BBB | 26Sep2021 | $65,150.75 | Sep2021 |
BBB | 27Sep2021 | $62,064.35 | Sep2021 |
BBB | 28Sep2021 | $65,286.50 | Sep2021 |
BBB | 29Sep2021 | $74,108.50 | Sep2021 |
BBB | 30Sep2021 | $57,026.85 | Sep2021 |
BBB | 01Oct2021 | $50,321.30 | Oct2021 |
BBB | 02Oct2021 | $68,916.50 | Oct2021 |
BBB | 03Oct2021 | $61,967.25 | Oct2021 |
BBB | 04Oct2021 | $60,661.45 | Oct2021 |
BBB | 05Oct2021 | $56,774.95 | Oct2021 |
BBB | 06Oct2021 | $60,903.20 | Oct2021 |
BBB | 07Oct2021 | $62,903.70 | Oct2021 |
BBB | 08Oct2021 | $58,736.00 | Oct2021 |
BBB | 09Oct2021 | $77,066.95 | Oct2021 |
BBB | 10Oct2021 | $84,933.70 | Oct2021 |
BBB | 11Oct2021 | $83,384.85 | Oct2021 |
BBB | 12Oct2021 | $82,313.35 | Oct2021 |
BBB | 13Oct2021 | $95,540.90 | Oct2021 |
BBB | 14Oct2021 | $76,573.45 | Oct2021 |
BBB | 15Oct2021 | $61,145.45 | Oct2021 |
BBB | 16Oct2021 | $49,458.80 | Oct2021 |
BBB | 17Oct2021 | $51,850.90 | Oct2021 |
BBB | 18Oct2021 | $52,277.80 | Oct2021 |
BBB | 19Oct2021 | $51,088.30 | Oct2021 |
BBB | 20Oct2021 | $53,936.90 | Oct2021 |
BBB | 21Oct2021 | $85,633.60 | Oct2021 |
BBB | 22Oct2021 | $87,616.80 | Oct2021 |
BBB | 23Oct2021 | $80,120.10 | Oct2021 |
BBB | 24Oct2021 | $84,162.40 | Oct2021 |
BBB | 25Oct2021 | $74,062.60 | Oct2021 |
BBB | 26Oct2021 | $78,458.85 | Oct2021 |
BBB | 27Oct2021 | $66,780.50 | Oct2021 |
BBB | 28Oct2021 | $64,465.40 | Oct2021 |
BBB | 29Oct2021 | $59,892.05 | Oct2021 |
BBB | 30Oct2021 | $57,148.75 | Oct2021 |
BBB | 31Oct2021 | $61,775.50 | Oct2021 |
BBB | 01Nov2021 | $62,327.05 | Nov2021 |
BBB | 02Nov2021 | $76,292.85 | Nov2021 |
BBB | 03Nov2021 | $80,971.25 | Nov2021 |
BBB | 04Nov2021 | $103,255.85 | Nov2021 |
BBB | 05Nov2021 | $98,249.90 | Nov2021 |
BBB | 06Nov2021 | $91,527.65 | Nov2021 |
BBB | 07Nov2021 | $94,687.10 | Nov2021 |
BBB | 08Nov2021 | $94,524.00 | Nov2021 |
BBB | 09Nov2021 | $95,217.40 | Nov2021 |
BBB | 10Nov2021 | $98,173.50 | Nov2021 |
BBB | 11Nov2021 | $94,379.90 | Nov2021 |
BBB | 12Nov2021 | $88,067.35 | Nov2021 |
BBB | 13Nov2021 | $85,319.00 | Nov2021 |
BBB | 14Nov2021 | $76,184.80 | Nov2021 |
BBB | 15Nov2021 | $72,103.10 | Nov2021 |
BBB | 16Nov2021 | $69,281.50 | Nov2021 |
BBB | 17Nov2021 | $63,891.35 | Nov2021 |
BBB | 18Nov2021 | $60,702.90 | Nov2021 |
BBB | 19Nov2021 | $52,189.95 | Nov2021 |
BBB | 20Nov2021 | $37,951.45 | Nov2021 |
BBB | 21Nov2021 | $35,057.60 | Nov2021 |
BBB | 22Nov2021 | $35,069.00 | Nov2021 |
BBB | 23Nov2021 | $53,596.05 | Nov2021 |
BBB | 24Nov2021 | $42,080.40 | Nov2021 |
BBB | 25Nov2021 | $57,672.00 | Nov2021 |
BBB | 26Nov2021 | $53,410.10 | Nov2021 |
BBB | 27Nov2021 | $69,835.70 | Nov2021 |
BBB | 28Nov2021 | $68,186.25 | Nov2021 |
BBB | 29Nov2021 | $67,516.80 | Nov2021 |
BBB | 30Nov2021 | $58,693.10 | Nov2021 |
BBB | 01Dec2021 | $67,221.90 | Dec2021 |
BBB | 02Dec2021 | $68,552.55 | Dec2021 |
BBB | 03Dec2021 | $66,715.75 | Dec2021 |
BBB | 04Dec2021 | $74,530.10 | Dec2021 |
BBB | 05Dec2021 | $74,624.49 | Dec2021 |
BBB | 06Dec2021 | $75,111.54 | Dec2021 |
BBB | 07Dec2021 | $97,989.70 | Dec2021 |
BBB | 08Dec2021 | $108,070.30 | Dec2021 |
BBB | 09Dec2021 | $96,085.40 | Dec2021 |
BBB | 10Dec2021 | $87,404.75 | Dec2021 |
BBB | 11Dec2021 | $79,679.15 | Dec2021 |
BBB | 12Dec2021 | $84,730.95 | Dec2021 |
BBB | 13Dec2021 | $88,696.75 | Dec2021 |
BBB | 14Dec2021 | $90,768.55 | Dec2021 |
BBB | 15Dec2021 | $81,273.65 | Dec2021 |
BBB | 16Dec2021 | $78,525.90 | Dec2021 |
BBB | 17Dec2021 | $79,152.35 | Dec2021 |
BBB | 18Dec2021 | $69,439.15 | Dec2021 |
BBB | 19Dec2021 | $70,354.65 | Dec2021 |
BBB | 20Dec2021 | $75,212.70 | Dec2021 |
BBB | 21Dec2021 | $109,569.10 | Dec2021 |
BBB | 22Dec2021 | $104,167.20 | Dec2021 |
BBB | 23Dec2021 | $84,007.10 | Dec2021 |
BBB | 24Dec2021 | $86,030.05 | Dec2021 |
BBB | 25Dec2021 | $76,240.70 | Dec2021 |
BBB | 26Dec2021 | $76,240.70 | Dec2021 |
BBB | 27Dec2021 | $75,323.60 | Dec2021 |
BBB | 28Dec2021 | $81,855.10 | Dec2021 |
BBB | 29Dec2021 | $72,802.10 | Dec2021 |
BBB | 30Dec2021 | $58,363.45 | Dec2021 |
BBB | 31Dec2021 | $67,338.35 | Dec2021 |
BBB | 01Jan2022 | $60,494.70 | Jan2022 |
BBB | 02Jan2022 | $60,494.70 | Jan2022 |
BBB | 03Jan2022 | $51,965.30 | Jan2022 |
BBB | 04Jan2022 | $60,172.75 | Jan2022 |
BBB | 05Jan2022 | $92,395.95 | Jan2022 |
BBB | 06Jan2022 | $60,746.50 | Jan2022 |
BBB | 07Jan2022 | $66,357.55 | Jan2022 |
BBB | 08Jan2022 | $71,823.70 | Jan2022 |
BBB | 09Jan2022 | $70,547.75 | Jan2022 |
BBB | 10Jan2022 | $71,141.65 | Jan2022 |
BBB | 11Jan2022 | $69,651.85 | Jan2022 |
BBB | 12Jan2022 | $88,444.45 | Jan2022 |
BBB | 13Jan2022 | $84,351.35 | Jan2022 |
BBB | 14Jan2022 | $84,880.25 | Jan2022 |
BBB | 15Jan2022 | $62,189.95 | Jan2022 |
BBB | 16Jan2022 | $60,482.80 | Jan2022 |
BBB | 17Jan2022 | $58,142.85 | Jan2022 |
BBB | 18Jan2022 | $57,913.40 | Jan2022 |
BBB | 19Jan2022 | $42,466.50 | Jan2022 |
BBB | 20Jan2022 | $55,680.45 | Jan2022 |
BBB | 21Jan2022 | $59,337.80 | Jan2022 |
BBB | 22Jan2022 | $58,056.60 | Jan2022 |
BBB | 23Jan2022 | $51,597.75 | Jan2022 |
BBB | 24Jan2022 | $43,988.75 | Jan2022 |
BBB | 25Jan2022 | $79,412.85 | Jan2022 |
BBB | 26Jan2022 | $66,645.15 | Jan2022 |
BBB | 27Jan2022 | $84,595.25 | Jan2022 |
BBB | 28Jan2022 | $84,391.70 | Jan2022 |
BBB | 29Jan2022 | $82,915.70 | Jan2022 |
BBB | 30Jan2022 | $69,843.70 | Jan2022 |
BBB | 31Jan2022 | $77,779.65 | Jan2022 |
BBB | 01Feb2022 | $101,843.85 | Feb2022 |
BBB | 02Feb2022 | $100,932.10 | Feb2022 |
BBB | 03Feb2022 | $86,523.10 | Feb2022 |
BBB | 04Feb2022 | $91,455.20 | Feb2022 |
BBB | 05Feb2022 | $74,873.95 | Feb2022 |
BBB | 06Feb2022 | $75,276.55 | Feb2022 |
BBB | 07Feb2022 | $79,204.00 | Feb2022 |
BBB | 08Feb2022 | $78,279.70 | Feb2022 |
BBB | 09Feb2022 | $77,596.30 | Feb2022 |
BBB | 10Feb2022 | $67,124.30 | Feb2022 |
BBB | 11Feb2022 | $66,958.55 | Feb2022 |
BBB | 12Feb2022 | $67,127.45 | Feb2022 |
BBB | 13Feb2022 | $66,392.10 | Feb2022 |
BBB | 14Feb2022 | $62,837.90 | Feb2022 |
BBB | 14Feb2022 | $62,837.90 | Feb2022 |
BBB | 15Feb2022 | $67,561.30 | Feb2022 |
BBB | 16Feb2022 | $72,985.50 | Feb2022 |
BBB | 17Feb2022 | $54,580.45 | Feb2022 |
BBB | 18Feb2022 | $57,716.60 | Feb2022 |
BBB | 19Feb2022 | $46,252.85 | Feb2022 |
BBB | 20Feb2022 | $45,357.00 | Feb2022 |
BBB | 21Feb2022 | $44,708.40 | Feb2022 |
BBB | 22Feb2022 | $48,242.90 | Feb2022 |
BBB | 23Feb2022 | $66,829.25 | Feb2022 |
BBB | 24Feb2022 | $62,615.40 | Feb2022 |
BBB | 25Feb2022 | $56,068.50 | Feb2022 |
BBB | 26Feb2022 | $45,547.30 | Feb2022 |
BBB | 27Feb2022 | $43,641.05 | Feb2022 |
BBB | 28Feb2022 | $46,446.85 | Feb2022 |
BBB | 01Mar2022 | $71,882.85 | Mar2022 |
BBB | 02Mar2022 | $82,893.10 | Mar2022 |
BBB | 03Mar2022 | $71,943.80 | Mar2022 |
BBB | 04Mar2022 | $82,351.00 | Mar2022 |
BBB | 05Mar2022 | $48,255.25 | Mar2022 |
BBB | 06Mar2022 | $39,908.50 | Mar2022 |
BBB | 07Mar2022 | $43,650.00 | Mar2022 |
BBB | 08Mar2022 | $40,008.85 | Mar2022 |
BBB | 09Mar2022 | $36,833.40 | Mar2022 |
BBB | 10Mar2022 | $34,605.20 | Mar2022 |
BBB | 11Mar2022 | $45,035.75 | Mar2022 |
BBB | 12Mar2022 | $62,863.65 | Mar2022 |
BBB | 13Mar2022 | $61,769.95 | Mar2022 |
BBB | 15Mar2022 | $51,181.45 | Mar2022 |
BBB | 16Mar2022 | $62,663.45 | Mar2022 |
BBB | 17Mar2022 | $96,220.35 | Mar2022 |
BBB | 18Mar2022 | $58,237.25 | Mar2022 |
BBB | 19Mar2022 | $40,792.40 | Mar2022 |
BBB | 20Mar2022 | $39,977.60 | Mar2022 |
BBB | 21Mar2022 | $42,186.50 | Mar2022 |
BBB | 22Mar2022 | $29,135.65 | Mar2022 |
BBB | 23Mar2022 | $18,418.85 | Mar2022 |
BBB | 24Mar2022 | $35,529.55 | Mar2022 |
BBB | 25Mar2022 | $45,812.00 | Mar2022 |
BBB | 26Mar2022 | $55,951.75 | Mar2022 |
BBB | 27Mar2022 | $55,521.40 | Mar2022 |
BBB | 28Mar2022 | $54,919.20 | Mar2022 |
BBB | 29Mar2022 | $73,971.80 | Mar2022 |
BBB | 30Mar2022 | $73,941.30 | Mar2022 |
BBB | 31Mar2022 | $67,127.60 | Mar2022 |
BBB | 01Apr2022 | $58,728.60 | Apr2022 |
BBB | 02Apr2022 | $48,748.20 | Apr2022 |
BBB | 03Apr2022 | $46,805.10 | Apr2022 |
BBB | 04Apr2022 | $49,253.10 | Apr2022 |
BBB | 05Apr2022 | $45,518.25 | Apr2022 |
BBB | 06Apr2022 | $65,281.30 | Apr2022 |
BBB | 07Apr2022 | $83,153.45 | Apr2022 |
BBB | 08Apr2022 | $91,813.35 | Apr2022 |
BBB | 09Apr2022 | $74,331.15 | Apr2022 |
BBB | 10Apr2022 | $66,985.80 | Apr2022 |
BBB | 11Apr2022 | $70,153.55 | Apr2022 |
BBB | 12Apr2022 | $60,232.55 | Apr2022 |
BBB | 13Apr2022 | $69,134.30 | Apr2022 |
BBB | 14Apr2022 | $78,892.35 | Apr2022 |
BBB | 15Apr2022 | $87,409.60 | Apr2022 |
BBB | 16Apr2022 | $78,869.20 | Apr2022 |
BBB | 17Apr2022 | $73,440.35 | Apr2022 |
BBB | 18Apr2022 | $71,972.45 | Apr2022 |
BBB | 19Apr2022 | $72,004.65 | Apr2022 |
BBB | 20Apr2022 | $82,696.80 | Apr2022 |
BBB | 21Apr2022 | $58,503.90 | Apr2022 |
BBB | 22Apr2022 | $56,770.90 | Apr2022 |
BBB | 23Apr2022 | $51,455.55 | Apr2022 |
BBB | 24Apr2022 | $49,806.50 | Apr2022 |
BBB | 25Apr2022 | $50,046.50 | Apr2022 |
BBB | 26Apr2022 | $50,818.20 | Apr2022 |
BBB | 27Apr2022 | $69,499.30 | Apr2022 |
BBB | 28Apr2022 | $72,221.05 | Apr2022 |
BBB | 29Apr2022 | $87,008.80 | Apr2022 |
BBB | 30Apr2022 | $80,994.75 | Apr2022 |
BBB | 01May2022 | $69,522.25 | May2022 |
BBB | 02May2022 | $65,384.20 | May2022 |
BBB | 03May2022 | $62,086.15 | May2022 |
BBB | 04May2022 | $58,661.90 | May2022 |
BBB | 05May2022 | $54,558.95 | May2022 |
BBB | 06May2022 | $61,361.00 | May2022 |
BBB | 07May2022 | $46,804.05 | May2022 |
BBB | 08May2022 | $54,195.60 | May2022 |
BBB | 09May2022 | $54,649.55 | May2022 |
BBB | 10May2022 | $72,433.30 | May2022 |
BBB | 11May2022 | $80,282.95 | May2022 |
BBB | 12May2022 | $74,588.45 | May2022 |
BBB | 13May2022 | $65,902.10 | May2022 |
BBB | 14May2022 | $56,845.60 | May2022 |
BBB | 15May2022 | $42,680.40 | May2022 |
BBB | 16May2022 | $43,203.65 | May2022 |
BBB | 17May2022 | $29,892.50 | May2022 |
BBB | 18May2022 | $28,719.80 | May2022 |
BBB | 19May2022 | $58,077.80 | May2022 |
BBB | 20May2022 | $66,657.50 | May2022 |
BBB | 21May2022 | $51,625.95 | May2022 |
BBB | 22May2022 | $51,274.80 | May2022 |
BBB | 23May2022 | $51,180.40 | May2022 |
BBB | 24May2022 | $47,937.45 | May2022 |
BBB | 25May2022 | $42,756.70 | May2022 |
BBB | 26May2022 | $42,733.85 | May2022 |
BBB | 27May2022 | $61,576.15 | May2022 |
BBB | 28May2022 | $62,690.55 | May2022 |
BBB | 29May2022 | $59,226.55 | May2022 |
BBB | 30May2022 | $63,753.10 | May2022 |
BBB | 31May2022 | $63,967.20 | May2022 |
BBB | 01Jun2022 | $55,030.70 | Jun2022 |
BBB | 02Jun2022 | $49,583.10 | Jun2022 |
BBB | 03Jun2022 | $63,213.65 | Jun2022 |
BBB | 04Jun2022 | $61,881.60 | Jun2022 |
BBB | 05Jun2022 | $62,210.85 | Jun2022 |
BBB | 06Jun2022 | $68,710.20 | Jun2022 |
BBB | 07Jun2022 | $80,981.45 | Jun2022 |
BBB | 08Jun2022 | $94,348.75 | Jun2022 |
BBB | 09Jun2022 | $84,032.25 | Jun2022 |
BBB | 10Jun2022 | $71,957.55 | Jun2022 |
BBB | 11Jun2022 | $60,715.50 | Jun2022 |
BBB | 12Jun2022 | $48,319.05 | Jun2022 |
BBB | 13Jun2022 | $41,362.05 | Jun2022 |
BBB | 14Jun2022 | $41,834.45 | Jun2022 |
BBB | 15Jun2022 | $42,841.55 | Jun2022 |
BBB | 16Jun2022 | $51,830.05 | Jun2022 |
BBB | 17Jun2022 | $57,919.10 | Jun2022 |
BBB | 18Jun2022 | $45,946.80 | Jun2022 |
BBB | 19Jun2022 | $45,248.25 | Jun2022 |
BBB | 20Jun2022 | $51,858.05 | Jun2022 |
BBB | 21Jun2022 | $56,045.85 | Jun2022 |
BBB | 22Jun2022 | $56,441.05 | Jun2022 |
BBB | 23Jun2022 | $65,078.95 | Jun2022 |
BBB | 24Jun2022 | $70,820.30 | Jun2022 |
BBB | 25Jun2022 | $49,524.05 | Jun2022 |
BBB | 26Jun2022 | $42,986.60 | Jun2022 |
BBB | 27Jun2022 | $36,350.40 | Jun2022 |
BBB | 28Jun2022 | $39,987.85 | Jun2022 |
BBB | 29Jun2022 | $40,963.65 | Jun2022 |
BBB | 30Jun2022 | $27,277.15 | Jun2022 |
BBB | 01Jul2022 | $30,494.55 | Jul2022 |
BBB | 02Jul2022 | $34,821.35 | Jul2022 |
BBB | 03Jul2022 | $33,002.30 | Jul2022 |
BBB | 04Jul2022 | $30,258.60 | Jul2022 |
BBB | 05Jul2022 | $39,502.50 | Jul2022 |
BBB | 06Jul2022 | $43,946.15 | Jul2022 |
BBB | 07Jul2022 | $63,412.00 | Jul2022 |
BBB | 08Jul2022 | $74,811.75 | Jul2022 |
BBB | 09Jul2022 | $82,668.05 | Jul2022 |
BBB | 10Jul2022 | $71,930.80 | Jul2022 |
BBB | 11Jul2022 | $62,608.75 | Jul2022 |
BBB | 12Jul2022 | $72,799.60 | Jul2022 |
BBB | 13Jul2022 | $77,587.90 | Jul2022 |
BBB | 14Jul2022 | $80,050.90 | Jul2022 |
BBB | 15Jul2022 | $74,513.70 | Jul2022 |
BBB | 16Jul2022 | $76,781.70 | Jul2022 |
BBB | 17Jul2022 | $64,326.05 | Jul2022 |
BBB | 18Jul2022 | $59,893.10 | Jul2022 |
BBB | 19Jul2022 | $56,366.75 | Jul2022 |
BBB | 20Jul2022 | $47,901.65 | Jul2022 |
BBB | 21Jul2022 | $48,026.30 | Jul2022 |
BBB | 22Jul2022 | $26,661.25 | Jul2022 |
BBB | 23Jul2022 | $18,504.60 | Jul2022 |
BBB | 24Jul2022 | $19,627.05 | Jul2022 |
BBB | 25Jul2022 | $15,803.30 | Jul2022 |
BBB | 26Jul2022 | $19,311.40 | Jul2022 |
BBB | 27Jul2022 | $18,658.45 | Jul2022 |
BBB | 28Jul2022 | $19,575.60 | Jul2022 |
BBB | 29Jul2022 | $17,735.90 | Jul2022 |
BBB | 30Jul2022 | $18,055.10 | Jul2022 |
BBB | 31Jul2022 | $19,558.25 | Jul2022 |
BBB | 01Aug2022 | $14,030.50 | Aug2022 |
BBB | 02Aug2022 | $10,015.75 | Aug2022 |
BBB | 03Aug2022 | $21,703.75 | Aug2022 |
BBB | 04Aug2022 | $69,839.40 | Aug2022 |
BBB | 05Aug2022 | $63,803.95 | Aug2022 |
BBB | 06Aug2022 | $82,075.10 | Aug2022 |
BBB | 07Aug2022 | $66,467.20 | Aug2022 |
BBB | 08Aug2022 | $67,752.90 | Aug2022 |
BBB | 09Aug2022 | $53,308.30 | Aug2022 |
BBB | 10Aug2022 | $40,976.70 | Aug2022 |
BBB | 11Aug2022 | $31,137.55 | Aug2022 |
BBB | 12Aug2022 | $46,586.55 | Aug2022 |
BBB | 13Aug2022 | $60,351.35 | Aug2022 |
BBB | 14Aug2022 | $53,569.40 | Aug2022 |
BBB | 15Aug2022 | $49,099.35 | Aug2022 |
BBB | 16Aug2022 | $52,714.30 | Aug2022 |
BBB | 17Aug2022 | $62,010.70 | Aug2022 |
BBB | 18Aug2022 | $69,334.05 | Aug2022 |
BBB | 19Aug2022 | $67,086.95 | Aug2022 |
BBB | 20Aug2022 | $54,652.40 | Aug2022 |
BBB | 21Aug2022 | $54,203.70 | Aug2022 |
BBB | 22Aug2022 | $51,724.05 | Aug2022 |
BBB | 23Aug2022 | $48,001.20 | Aug2022 |
BBB | 24Aug2022 | $47,614.10 | Aug2022 |
BBB | 25Aug2022 | $63,837.75 | Aug2022 |
BBB | 26Aug2022 | $77,436.75 | Aug2022 |
BBB | 27Aug2022 | $64,959.20 | Aug2022 |
BBB | 28Aug2022 | $60,353.05 | Aug2022 |
BBB | 29Aug2022 | $67,559.10 | Aug2022 |
BBB | 30Aug2022 | $80,936.80 | Aug2022 |
BBB | 31Aug2022 | $74,392.25 | Aug2022 |
BBB | 01Sep2022 | $59,384.45 | Sep2022 |
BBB | 02Sep2022 | $52,789.55 | Sep2022 |
BBB | 03Sep2022 | $36,312.35 | Sep2022 |
BBB | 04Sep2022 | $38,265.00 | Sep2022 |
BBB | 05Sep2022 | $34,688.85 | Sep2022 |
BBB | 06Sep2022 | $36,271.95 | Sep2022 |
BBB | 07Sep2022 | $32,638.95 | Sep2022 |
BBB | 08Sep2022 | $43,105.05 | Sep2022 |
BBB | 09Sep2022 | $49,971.55 | Sep2022 |
BBB | 10Sep2022 | $62,217.15 | Sep2022 |
BBB | 11Sep2022 | $58,348.40 | Sep2022 |
BBB | 12Sep2022 | $53,416.60 | Sep2022 |
BBB | 13Sep2022 | $55,198.15 | Sep2022 |
BBB | 14Sep2022 | $65,310.35 | Sep2022 |
BBB | 15Sep2022 | $66,609.45 | Sep2022 |
BBB | 16Sep2022 | $83,554.55 | Sep2022 |
BBB | 17Sep2022 | $83,806.00 | Sep2022 |
BBB | 18Sep2022 | $80,007.85 | Sep2022 |
BBB | 19Sep2022 | $78,824.75 | Sep2022 |
BBB | 20Sep2022 | $84,380.35 | Sep2022 |
BBB | 21Sep2022 | $86,396.15 | Sep2022 |
BBB | 22Sep2022 | $77,992.25 | Sep2022 |
BBB | 23Sep2022 | $71,595.20 | Sep2022 |
BBB | 24Sep2022 | $53,406.95 | Sep2022 |
BBB | 25Sep2022 | $51,405.05 | Sep2022 |
BBB | 26Sep2022 | $50,723.85 | Sep2022 |
BBB | 27Sep2022 | $42,596.60 | Sep2022 |
BBB | 28Sep2022 | $40,856.50 | Sep2022 |
BBB | 29Sep2022 | $40,634.75 | Sep2022 |
BBB | 30Sep2022 | $41,948.00 | Sep2022 |
Is your DATE a SAS date value or a string?
Is your Amount1 actually numeric?
Do you want a report for people to read or a data set?
If your date is actually a SAS date value with an apparent Date9 format then using a different format in a report or analysis procedure will group by the formatted values.
Create a data set
Proc summary data=have nway; class location business_date; format business_date yymon7. ; var Amount1; output out=want (drop=_: ) mean= ; run;
One of many ways to make a report:
Proc means data=have mean; class location business_date; format business_date yymon7. ; var Amount1; run;
Groups created by formats will be honored by report and analysis procedures and most formats will work with graphic procedures as well.
@Eugenio211 wrote:
I got this error using your proc summary:
ERROR: Variable AMOUNT1 in list does not match type prescribed for this list.
Which points to AMOUNT1 being of type character. Is this so (run PROC CONTENTS)?
Boy, that's a lot of sample data 🙂
Did the code work for you?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.