Problem with Set Analysis

[#1]

Hi all,

Somebody can help me?

I am beginning to use set Analysis.

in the sample attched I want to create a Pivot Table with the dimension year and dept.

I want to show only rows in which the sum of sales for the dept is greater than the avg of sales for all dept every year.

Thank All

[#2 · Accepted solution]

Hi,

This is the best I could do. It doesn't use set analysis, but aggr().

Regards,

[#3]

Thank 1000 Wernbrenk.

It is very goog