Pivot Table Help

[2mooreengineers]

I have a data set with a group of data repeated each year. For example, I have data on schools over a 10 year period. Each school has multiple columns of data. The data needs to be compared for each school across the years to identify trends and needs to be compared to other schools in the state. I would like to use pivot tables to create charts and ultimate develop a dashboard.

How do I set up the pivot table to trend the data over time? Additionally, how do I show the exact value in the data field when I create the pivot table as oppose to a count, sum, average or another aggregate?

 

[awoohaw]

HI @2mooreengineers , Mr. Excel has an Add In tool, xl2bb that allows you to post mini sheets of your data. Which would be VERY helpful to your question.
You're asking the forum to create your data randomly based upon which you vaguely describe. To avoid errors and confusion, and to get timely replies please use the tool. If for some reason you cannot use the tool then please post your data as a table. Help the forum help you.

Thanks in advance.