Forum Discussion

Omaria1575's avatar
Omaria1575
Copper Contributor
Mar 11, 2020
Solved

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 ...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 12, 2020

    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.

Omaria1575's avatar
Omaria1575
Copper Contributor
Mar 12, 2020

Riny_van_Eekelen In Column E (labeled Parking Lot), if you scroll down, to data starting in February where there is "Private/Public" written. This is only written in cells where cells are labeled Arts District is and the crime is labeled as a "BTFV". I don't have this information for January but started in February to try to section this out.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 12, 2020

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.

Resources