Last yr value

[sathishkumar_go]

Hi,

In my table, i have Fiscalyrwk,FcMonth,FcQtr.

Example

FiscalYrwk FcMonth FcQtr Value

200852 200812 200804 500

200952 200912 200904 1000

201052 201012 201004 2000

Now I want,

In chart (Line chart)

Dimension -- FiscalyrWk

expression i want to show current yr value and last yr value (i.e 201052 -> 2000 as well 1000)

I know it is possible to pull once again the table and use Applymap. i want to know wheather setanalysis itself it is possible can do?

I am waiting for ur reply.....

-Sathish

[#2]

Hi Sathish,

sorry, but as far as I know it isn't possible using week as dim and showing the values for 200948 and 201048 above each other as you did in your workaround in your chart. Your Week(-Year) depends on the year, this is that the values depend also on the year and can't be shown above each other. So I would follow up your idea with creating these values during load and store them in seperate fields. Then you can use the Week(-Year) as dim.

RR