Get the average monthly

[Eugenio211]

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

[ballardw]

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]

I got this error using your proc summary:

ERROR: Variable AMOUNT1 in list does not match type prescribed for this list.

[Kurt_Bremser]

---

@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)?

[Eugenio211]

please disregard the error message.

[PeterClemmensen]

Boy, that's a lot of sample data 🙂

Did the code work for you?