• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Entry level user - Please can someone help with Pivot Table analysis?

Beth1

New Member
Hi all, I wonder if someone can help me ascertain key information re: Violence against the person in the attached file? I think I need to combine 2 tables but am unsure how to best represent them?
 

Attachments

  • Analyst Test.xlsx
    265.5 KB · Views: 4
Beth,
Please take the data in the Section England North East and show us a mocked up solution of what you want in your analysis. You have not provided us with any criteria for your needed analysis. Explain also what you are trying to determine.
 
Thank you for your replies.
Trying to understand recent published figures in this area at national and police force level by identifing key messages from statistical tables. Ensure that statistics are correctly interpreted and used in communication to decision-makers and the general public.

For Table 3, I was trying to show a trend for increasing Violence and Stalking but a decrease in Homicide and Death or serious injury - unlawful driving. I am familiar with pivot tables biu entry level.
Was hoping to see what / how this could be done to highlight the above factors. Any help would be appreciated. Or possibly a suggestion where I could upskill to teach myself ?
 
Beth,
Please take the data in the Section England North East and show us a mocked up solution of what you want in your analysis. You have not provided us with any criteria for your needed analysis. Explain also what you are trying to determine.
thank you.
 
Back
Top