L luzz Registered User. Local time Yesterday, 20:53 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: 80
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, 04:53 Joined Feb 19, 2013 Messages 17,763 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)
