How does excel do Top 10 in pivot

[SD]

Hello All,

Can any one tell me what logic does excel use to get top 10 or top 5
in the pivot. I am asking this because when you have a time series
data you should ideally have Top 3 for each month or year but it just
gives a list of products , now I wanted to know what basis, is it by
the latest month or the first month.


e.g

Cat Jan08
Feb08 mar08
A 34
56 78
b 56
45 67
c 12
78 94

If I were to ask excel the top 1 cat which one would it pick and how ,
any help in making it simple would be great .

thanks
SD

 

[David Heaton]

Hello All,

Can any one tell me what logic does excel use to get top 10 or top 5
in the pivot. I am asking this because when you have a time series
data you should ideally have Top 3 for each month or year  but it just
gives a list of products , now I wanted to know what basis, is it by
the latest month or the first month.

e.g

Cat                    Jan08
Feb08                        mar08
A                        34
56                              78
b                         56
45                              67
c                         12
78                              94

If I were to ask excel the top 1 cat which one would it pick and how ,
any help in making it simple would be great .

thanks
SD

A pivot table based on data within your sheet will take the first time
period as the basis for the TOP count.

However if it is pivot table based on an OLAP cube the criteria would
be based on the default time period OR the time period specified in
the PAGE FIELD area

Regards

David