Ive created some dummy data and layout, but the data source im using is very similar but with like 30 different columns and lots of data
I was wondering if you can create a pivot table like the lower 2 parts of the image from the data set at the top.
That is the diagram my boss gave me on how he'd like reports formatted. Im struggling to get row headings of a Value in money (Sum) with No below it as the number of occurences (count)
Its possible just compiling a normal table with formulas, but i was wanting to achieve it as a pivot table where i could then easily seperate by month or region etc.
Thanks in advance
Bookmarks