Breakdown data (1 Viewer)

luzz

Registered User.
Local time
Today, 06:43
Joined
Aug 23, 2017
Messages
346
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
    Breakdown of data.png
    26.5 KB · Views: 33

CJ_London

Super Moderator
Staff member
Local time
Today, 13:43
Joined
Feb 19, 2013
Messages
16,555
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)
 

Users who are viewing this thread

Top Bottom