Compare Prices

[#1]

Hi,

I’m trying to create a line chart that compares stock prices. I would like the prices to start at the same value. I’ve tried using the top function (Value / top(Value)), but it doesn’t seem to work. Any ideas?

My table looks like this:

Date	Stock	Value
01.01.2012	Stock A	100
01.01.2012	Stock B	10
01.01.2012	Stock C	300
02.01.2012	Stock A	102
02.01.2012	Stock B	9
02.01.2012	Stock C	310
03.01.2012	Stock A	105
03.01.2012	Stock B	8
03.01.2012	Stock C	320

Regards,

Tore

[CELAMBARASAN]

Hi,

     Use Max(Value).

Celambarasan

[#3]

Do you mean Max(Value) / Top(Value)? I get the same result, see attached file.

Tore

[jagan]

Hi,

Can you explain what the output would be.

Regards,

jagan.

[#5]

Se the attached file. I've removed stock from dimension and used set analysis. I want the same output with stock as a dimension.

[CELAMBARASAN]

Hi,

     Could you upload screen shot of that chart i cann't open your file because im using personal edition?

Celambarasan

[#7]

See attached file

[jagan · Accepted solution]

Hi,

Check the attached file for solution.

Regards,

Jagan.