Hoe to Calculate Previous Month Values

[Revathi_M]

Hi
I have list CurrentMonth/Week Column i want  calculation PreviousMonth/Week Colume

Delow List I need if Single Row  PreviousValues= '-'
example below table first row and last row
if Grouping Row previous values Display Depending  y_M_D/w  based Current Values
for example 13-M12 prevoues =Current values(13-M11) is that value Display 13-M12=8
13_M11 prevois Values is Not Details group

same If 13-w40 Display previous urrent Values=45

Here M=month,W=week

Code     y_M_D/w    CurrentValues      PreviousValues
-------------------------------------------------------------------
10         13-M10       1                                 -
------------------------------------------------------------------
15         13-M11       8                               -
           13-M12        4                               8
            14-M01       13                             4
           13-w39         45                            -
           13-w40         33                             45
-------------------------------------------------------------------------
20       14_W 41       44                             -
---------------------------------------------------------------------------

[MFGF]

Hi
I have list CurrentMonth/Week Column i want  calculation PreviousMonth/Week Colume

Delow List I need if Single Row  PreviousValues= '-'
example below table first row and last row
if Grouping Row previous values Display Depending  y_M_D/w  based Current Values
for example 13-M12 prevoues =Current values(13-M11) is that value Display 13-M12=8
13_M11 prevois Values is Not Details group

same If 13-w40 Display previous urrent Values=45

Here M=month,W=week

Code     y_M_D/w    CurrentValues      PreviousValues
-------------------------------------------------------------------
10         13-M10       1                                 -
------------------------------------------------------------------
15         13-M11       8                               -
           13-M12        4                               8
            14-M01       13                             4
           13-w39         45                            -
           13-w40         33                             45
-------------------------------------------------------------------------
20       14_W 41       44                             -
---------------------------------------------------------------------------

Are you using a relational or a dimensional package? The approach you take for this will differ drastically depending on the answer.

MF.

[Revathi_M]

Hi MFGF,

I am Working Relational Database
10.2 cognos Server


please it is Urgent Requirement please help me.

Thnaks
Revathi_M

[MFGF]

Hi MFGF,

I am Working Relational Database
10.2 cognos Server


please it is Urgent Requirement please help me.

Thnaks
Revathi_M

Ok - so the data is in a relational database, but your package could either be a dimensional package (dimensions, hierarchies, levels, members) or it could be a relational package (query subjects and query items). Which do you have?

MF.

[Revathi_M]

Hi MFGF,

Thanks u r replay,
my package is relational package (query subjects and query items)


Thnaks
Revathi_M

[MFGF]

Hi MFGF,

Thanks u r replay,
my package is relational package (query subjects and query items)


Thnaks
Revathi_M

Ok - in that case you need to add a second query. In this query you will need to include Code and CurrentValues. You will need to rename CurrentValues to PreviousValues, and you will need to create a query calculation that takes the y_M_D/w item and converts it to the next value (eg 13-M11 becomes 13-M12). It would make life easy if you call this calculation y_M_D/w too. Join the two queries together based on both Code and y_M_D/w (remembering that this is a calc in the second query) and then base your list on the contents of the new, joined query.

MF.

[Revathi_M]

Hi MFGF,
If don't kind
Please  Explain clear.....

I need Urgent.........





Thanks
REVATHI_M

[MFGF]

Hi MFGF,
If don't kind
Please  Explain clear.....

I need Urgent.........





Thanks
REVATHI_M

What have you tried? How far did you get with trying to implement the approach I outlined? What parts are you struggling with?

Please (please please) stop trying to push posters into anwering by insisting "it is urgent". While you may be under some pressure, most everyone who inhabits these pages also has a job and deadlines and is under pressure too. People will help if they can, and if they have time, but you stating again and again "it is urgent" will most likely deter them from answering at all, as it lends the impression you are being demanding where you have no right to be.

My advice here is for you to take some time and explain what you have tried. The post I added previously gave you steps - haw far did you get? What parts are you struggling with?

MF.