Function First...

[#1]

Hi all,

I have two problems with Pivot Table:

in the sample attached (with your help some days ago), there rae 2 tables:

1 - In Tab.1 I want to show only first 3 observations for every year with more sales.

2 - In Tab.2, when I open the QLV document, I want to show only the first Dept. The name of the dept. in the text object, and than change dept with the list near.

Thank All

[#2]

Hi,

use a dynamic dimension like:

=Aggr(If(Rank(Sum(Sales)) <=3, Dept, 'Others'), Dept)

One step forward.

Rainer

[#3]

Thank Rainer,

and if I want to sort the Pivot Table by Year and by descending Sum(Sales) (of Dept.).

Thank 1000