Rangeavg in reverse

[Anonymous]

Hi Guys,

i have input table like

tab:

load * inline [

ID,Sale

1,100

2,200

3,500

4,600 ]

i need out put in pivot table like

ID                        4,3,2,1

Rangeavg         350,267,150,100

Regards,

Mahesh

[tresesco · Accepted solution]

Try like:

[antoniotiman]

Hi Mahesh,

try this Expression

RangeAvg(Bottom(Sum(Sale),1,NoOfRows()-RowNo()+1))

Regards,

Antonio

[Anil_Babu_Samineni]

May be this?

RangeAvg(Below(Avg(Sale),0),Above(Sale,1,RowNo(Total)))

And if pivot table, Amy be this

RangeAvg(After(Sale,0,Count(TOTAL DISTINCT ID)))

[Anil_Babu_Samineni]

This may work Column level not the Row Level like Transpose for ID ??

[antoniotiman]

RangeAvg(Last(Sum(Sale),1,NoOfColumns()-ColumnNo()+1))

[tresesco]

And a more efficient expression could be :     RangeAvg(After(Sale,0,NoOfColumns()))