Average without a Max and min value in Aggregation

[Anonymous]

Hi all

I have this:

Producto	PRECIO	TIENDA
1	10	1
1	31	1
1	4	1
1	2	1
2	4	1
2	7	1
2	5	1
2	10	1
1	5	2
1	10	2
1	15	2
2	10	2
2	20	2
2	20	2
2	30	2

I would like to have the average for each "TIENDA" and "PRODUCTO" without the max and the min value for each agregation.

TIENDA 1:     PRODUCTO 1     AVERAGE 17.5

TIENDA 1:     PRODUCTO 2     AVERAGE 6

TIENDA 2:     PRODUCTO 1     AVERAGE 10

TIENDA 2:     PRODUCTO 2     AVERAGE 20

I'm going to use in a expression of a simple table chart using TIENDA as dimension

I need Helpppppppppppp .... I'll pay you a beer ..... or two

Regards

M

[Anil_Babu_Samineni]

First one Average is 11.5 ??? or 17.5 ???

May be this?

Create Straight Table and dimensions are Tienda, Producto

Expression simple Avg(PRECIO)

[Anil_Babu_Samineni]

I need Helpppppppppppp .... I'll pay you a beer ..... or two

Hahaha, Don't offer only for Beer. Why not deposit amount to my bank ??

[shiveshsingh]

Take Avg function as expression.

tienda and producto as dimension.

[Anonymous]

HI all

Maybe I explained bad...

I would like to have the average of PRECIO in  every cross of TIENDA and PRODUCTO excluding the maxim and minimun value for each cross.

The result I post was what I want .... then mean for TIENDA 1:     PRODUCTO 1     AVERAGE 17.5 is because for this cross I don't use 10 (is the max) and  2 (is the minimum)

Regards

M

[Anil_Babu_Samineni]

Got it, But here again i doubt whether how you say 10 is Maximum. seems 31 is Max for you? and 2 is minimum. You need to exclude these but output should come 7 only. Please help me to figure out this?

[Anil_Babu_Samineni]

check this? It may helps you

Sum(Aggr(Avg({<PRECIO -= {'$(=Max(PRECIO))', '$(=Min(PRECIO))'}>} PRECIO), Producto, TIENDA))

[Anonymous]

HI Anil

Thanks for all

I'll give you more information ... in our chart the unique dimension is "TIENDA", not "PRODUCTO", we want that the result be the sum of the average of "PRECIOS" for every "PRODUCTO"excluding MAx an MIn of each "PRODUCTO".

The result should be:

average excluding (MIN Max) PRODUCTO1 TIENDA 1 = 17.5

average excluding (MIN Max) PRODUCTO2 TIENDA 1 = 6

SUM=23.5

average excluding (MIN Max) PRODUCTO1 TIENDA 2 = 10

average excluding (MIN Max) PRODUCTO2 TIENDA 2 = 20

SUM=30

TIENDA	RESULT
1	23.5
2	30

thank you very much

M

[Anil_Babu_Samineni]

Finally point from my end - How 17.5 Comes into the picture?

[Anonymous]

Sorry .... my fault ... i GIVE YOU BAD THE AVERAGE ... in resume

we have 4 PRECIOS for PRODUCTO 1,

10, 31, 4 y 2

The mean excluding the max and in value is (10+4)/2 = 7

SORRYYYYYY

REGARDS

M.