Forum Discussion
Pivot table
Hi, I need to put the "count" as value but I cannot find it. I think my version of excel is the newest.
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"
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?
- Instead of putting WarNum as your axis, I'd put StartYear1 there because you want time in the axis