Pivot table

Copper Contributor

 Hi, I need to put the "count" as value but I cannot find it. I think my version of excel is the newest. Screen Shot 2019-10-25 at 10.07.25 AM.pngScreen Shot 2019-10-25 at 10.07.39 AM.png

5 Replies
I think you can click on the dropdown next to "Sum of WarNum" under "Values" and go to "Value Field Settings" and change it from "Sum" to "Count". Hope that works!

@JakeExcel hi yeah, I did that already I just dont understand why the ones on the filter aren't showing up on the table. im very confused

I see that you have "StartYear1" as a filter, but if you want its values to show up on your table, I would drag it over so that it's under "Values"

 

Screen Shot 2019-10-25 at 10.36.12 AM.png

 I have to create a bar chart but it doesn't seem accurate. I am not sure, is there anything I might have done wrong?

@JakeExcel 

Instead of putting WarNum as your axis, I'd put StartYear1 there because you want time in the axis