Pivot Table Question

[Jim]

Is it possible to use a pivot table to simply list data? I would like
to be able to list data in a pivot table with an function/formula
being applied. For example, I have a list that has the % of Time
Spent and I would like to display those percentages, not the sum of
the percentages or the count of the percentages.

Thanks

 

[ShaneDevenshire]

Hi,

Pivot Tables summarize data, so what are you basing the summary (grouping)
on? Show us some sample data and what you want it to look like.

For example
5%
5%
10%
11.2%
4%
10%

do you want each different % listed once or everytime that it appears?
4%
5%
10%
11.2%

 

[Jim]

Well the table, put simply, the data table would be setup like this:

Aug Sept

Tim 5% 5%
Jane 7% 8%
Dick 12% 13%
George 2% 3%
Phil 6% 10%
Mike 4% 6%

So, I have a very large table of this data. I would like the Pivot
table to show the data to me just like it is shown there and calculate
the variance.
It would be:

Aug Sept Var

Tim 5% 5% 0
Jane 7% 8% 1
Dick 12% 13% 1
George 2% 3% 1
Phil 6% 10% 4
Mike 4% 6% 2

This is very basic, but I am trying to use the Pivot Table to list and
sort, as well as calculate.