Pivot table

Question

Hi, I need to put the "count" as value but I cannot find it. I think my version of excel is the newest.&nbsp;

jakeexcel · Answer

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!

gabriellerocha · Answer

JakeExcel&nbsp;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

jakeexcel · Answer

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"

gabriellerocha · Answer

&nbsp;&nbsp;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&nbsp;

jakeexcel · Answer

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

Forum Discussion

Pivot table

Share

Resources