How to do this (pivot tables)

[Kotika]

I have a spreadsheet with 3 columns. Itemnumber, quantity and gender.

I put itemnumber in rows, quantity in columns and gender in value, but the outcome looks weird and im not sure i understand the assignment correctly.

The question is

I need to create a pivot table that sorts the data by item number, and quantity per item number. After that, create two separate columns in the pivot table that sort by gender


Can someone help me? Thank you

 

[SpillerBD]

Drop Item Number in Rows, Gender in Rows and Quantity in SIGMA