Summing categories from multiple table and creating an monthly report

Start Date Jan. 01, 2019
End Date Jan. 20, 2019


TALBE A TALBE B TALBE C
DATE CATEGORY VALUE DATE CATEGORY VALUE DATE CATEGORY VALUE
Dec. 21, 2019 Apple $20.00 Dec. 21, 2019 Apple $20.00 Dec. 21, 2019 Apple $20.00
Dec. 09, 2019 Orange $50.00 Dec. 09, 2019 Orange $50.00 Dec. 09, 2019 Orange $50.00
Nov. 20, 2019 Apple $20.00 Nov. 20, 2019 Apple $20.00 Nov. 20, 2019 Apple $20.00
Nov. 01, 2019 Orange $50.00 Nov. 01, 2019 Orange $50.00 Nov. 01, 2019 Orange $50.00
Oct. 24, 2019 Apple $20.00 Oct. 24, 2019 Apple $20.00 Oct. 24, 2019 Apple $20.00
Oct. 13, 2019 Orange $50.00 Oct. 13, 2019 Orange $50.00 Oct. 13, 2019 Orange $50.00
Sep. 24, 2019 Apple $20.00 Sep. 24, 2019 Apple $20.00 Sep. 24, 2019 Apple $20.00
Sep. 05, 2019 Orange $50.00 Sep. 05, 2019 Orange $50.00 Sep. 05, 2019 Orange $50.00
Aug. 26, 2019 Apple $20.00 Aug. 26, 2019 Apple $20.00 Aug. 26, 2019 Apple $20.00
Aug. 17, 2019 Orange $50.00 Aug. 17, 2019 Orange $50.00 Aug. 17, 2019 Orange $50.00
Jul. 29, 2019 Apple $20.00 Jul. 29, 2019 Apple $20.00 Jul. 29, 2019 Apple $20.00
Jul. 10, 2019 Orange $50.00 Jul. 10, 2019 Orange $50.00 Jul. 10, 2019 Orange $50.00
Jun. 21, 2019 Apple $20.00 Jun. 21, 2019 Apple $20.00 Jun. 21, 2019 Apple $20.00
Jun. 02, 2019 Orange $50.00 Jun. 02, 2019 Orange $50.00 Jun. 02, 2019 Orange $50.00
May. 26, 2019 Apple $20.00 May. 26, 2019 Apple $20.00 May. 26, 2019 Apple $20.00
May. 14, 2019 Orange $50.00 May. 14, 2019 Orange $50.00 May. 14, 2019 Orange $50.00
Apr. 25, 2019 Apple $20.00 Apr. 25, 2019 Apple $20.00 Apr. 25, 2019 Apple $20.00
Apr. 06, 2019 Orange $50.00 Apr. 06, 2019 Orange $50.00 Apr. 06, 2019 Orange $50.00
Mar. 23, 2019 Apple $20.00 Mar. 23, 2019 Apple $20.00 Mar. 23, 2019 Apple $20.00
Mar. 18, 2019 Orange $50.00 Mar. 18, 2019 Orange $50.00 Mar. 18, 2019 Orange $50.00
Feb. 27, 2019 Apple $20.00 Feb. 27, 2019 Apple $20.00 Feb. 27, 2019 Apple $20.00
Feb. 08, 2019 Orange $50.00 Feb. 08, 2019 Orange $50.00 Feb. 08, 2019 Orange $50.00
Jan. 20, 2019 Apple $20.00 Jan. 20, 2019 Apple $20.00 Jan. 20, 2019 Apple $20.00
Jan. 01, 2019 Orange $50.00 Jan. 01, 2019 Orange $50.00 Jan. 01, 2019 Orange $50.00

ANNUAL VALUE TOTALSUM
JAN FEB MAR APR MAY JUN
Apple TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL
Orange TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL
JUL AUG SEP OCT NOV DEC
Apple TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL
Orange TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL