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

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%


--
Thanks,
Shane Devenshire


"Jim" wrote:

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

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.