L luzz Registered User. Local time Today, 01:36 Joined Aug 23, 2017 Messages 346 Feb 21, 2018 #1 Hi there, How can I break down my data into the image I have attached after grouping all the data together. Attachments Breakdown of data.png 26.5 KB · Views: 81
Hi there, How can I break down my data into the image I have attached after grouping all the data together.
C CJ_London Super Moderator Staff member Local time Today, 09:36 Joined Feb 19, 2013 Messages 17,748 Feb 21, 2018 #2 use a crosstab query (which will also do your grouping, so work from your original data) use colour for row heading, lot for column heading and pounds for value (as a sum)
use a crosstab query (which will also do your grouping, so work from your original data) use colour for row heading, lot for column heading and pounds for value (as a sum)
