CODEWITHSUNDEEP
business-objectswebi
PLaks
PLaks

Reputation: 3

Is there a way to select a range of cells at the end of each column on a cross table to perform a calculation

I need to select a range of the last 3 to 5 cells w/in each column and calculate an average to which the result needs to be output beneath the selected cells.

webi results

Desired output modeled in Excel

Upvotes: 0

Views: 158

Answers (1)

Castiell
Castiell

Reputation: 167

Maybe you may try to add a rank dimension that you add in your table (then you hide) and you compute your avg(columnName where rank > value) 2 ways to do it - the rank should be in desc order then in the avg --> rank<=5 - the rank is in esc order --> You will need to use count() to get the number of line - 5

Upvotes: 0

Related Questions