Forum Discussion
Pivot Table with some data
Hey All,
I have a data source attached that outlines crime, I want my pivot table on the 'Type AD' tab to show the crime that occurs on private property. I created a column in my original data 'Comparative 2020' to outline private or public property next to the data that happens in the Arts District. I only want what is public/private for that specific district, can that be added to my graph on the 'Type AD' tab? I also want it to reflect in a different color and the total. I'm not sure that because I don't have data for January that it will work...help! Thank you!
Omaria1575 Okay! I never scrolled so far down. Starting to see what you are after and believe I worked it out. Extended the source for the PT and split up the "Parkinglot" column into two . One column for Private and One for Public. A 1 in the respective column indicates what it type it is.
See attached and let me know if this will work for you.
7 Replies
Yes, you can filter the pivot table using the 'Comparative 2020' column to show only private/public crimes in the Arts District. Use it as a filter or row label, apply color formatting for clarity, and show totals. Even if January is missing, it will still work. This also helps promote fairness by clearly showing how crime is distributed across property types.
Omaria1575 Not entirely sure I understood, but perhaps like in the attached file.
Riny_van_Eekelen I want it to show me the number of crimes that happened within that given month on private property, but I want it to be displayed on the graph (the # of private property crimes to show orange, for example, with the corresponding number associated with it).
Omaria1575 Please explain first how to determine a property to be private or public. Your data has a column the captures "Violent/Property". From the location it is not clear wether a property is private or public.
