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 -
---------------------------------------------------------------------------
Quote from: Revathi_M on 01 Dec 2014 06:58:54 AM
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.
Hi MFGF,
I am Working Relational Database
10.2 cognos Server
please it is Urgent Requirement please help me.
Thnaks
Revathi_M
Quote from: Revathi_M on 01 Dec 2014 11:13:46 PM
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.
Hi MFGF,
Thanks u r replay,
my package is relational package (query subjects and query items)
Thnaks
Revathi_M
Quote from: Revathi_M on 02 Dec 2014 07:27:41 AM
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.
Hi MFGF,
If don't kind
Please Explain clear.....
I need Urgent.........
Thanks
REVATHI_M
Quote from: Revathi_M on 03 Dec 2014 12:56:20 AM
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.