above function

[#1]

Hi,

Pls help,

Id	ITD
1	2
2	4
3	6
4	3
5	1
6	7
7	5

my table look like this above and I want a result like this..

Id	ITD	Expression
1	2	-
2	4	2
3	6	4
4	3	6
5	1	6
6	7	6
7	5	7

what expression suits here..?I tried for =Above(Max(ITD)) but its not considering above previous values whether there is any other function apart from above..?

[swuehl]

You are using two dimensions, right?

Then you need to use the total qualifier, to get around the column segments:

=Above(TOTAL Max(ITD))

[#3]

Hi Thanks for your replyb but answer is not coming for the above expression.....

[swuehl]

Seems to work for me.

Please post a small sample that demonstrates your issue.

[#5]

Hi swuehl,

So I have a similar issue: I have two dimensions and a rangesum(above ...) expression. I use the TOTAL statement so that it takes care of the multiple dimension problem.

I get the pivot table to work as wanted and the figures are correct!

Now to my problem: I want to display the output in a line-chart, in fact convert the pivot to a line chart to rather disply it graphically as two lines plotted, one for each dimension (in my case plotted on time dimension, and the time dimension must be the first sorted dimension).

I do not get this to work ....... Do you have any suggestions??

Thank you!

David

[#6]

Hi sathiyanc,

Please see if the attached app resolves your issue.

Kind Regards,

Footsie