How can i carry forward values in crosstab?

shrini · 12 Feb 2010 01:16:24 PM

HI

How can carry forward my row value when dont have values for the next when i dont have for next,let me give a pic of the requirement ---

|
| 2000 2001 2002 2003
-------------|---------------------------------------------------------------------------------------- |
Product1 | 5 10
|
|
Product2 | 2 4
|
Product3 | 10 9 8
|
Product4 | 11 14

Case1:-Product1----2000,2001,2002,2003
So when we consider for product1 for 2000,2001,2002,2003 we have values for 2000 and 2001 as 5 and 10 so i need value of 2001 i.e 10 to carry forward for 2002,2003

Case2:Product2----2000,2001,2002,2003:--
So for product2 we have value '2' for 2000 and it should be carried forward for the year 2001(the same value of
2001) and similarly 2002 value '4' should be carried forward for 2003.

and similary for product 3 and product4

So pls get me back if anybody knows how to meet the requirement.

Thanks,
Shrini

shrini · 04 Mar 2010 11:45:03 AM

<html>
<head>
   <script type="text/javascript">
      var arr = ["p2","t2","c2","o2"];
      function $(id){return document.getElementById(id);}
      function handle(obj){
         resetInputs();
         $(obj).disabled=true;
      }
      function resetInputs(){
         for(var i=0;i<arr.length;i++){
            $(arr).disabled=false;
         }
      }
   </script>
</head>
<body>
   <table cellpadding="5px"><tr><td>
   <input type="radio" value="P" name="g1" id="p1" onclick="handle('p2');">P</input>

   <input type="radio" value="T" name="g1" id="t1" onclick="handle('t2');">T</input>

   <input type="radio" value="C" name="g1" id="c1" onclick="handle('c2');">C</input>

   <input type="radio" value="O" name="g1" id="o1" onclick="handle('o2');">O</input>
   </td><td>
   <input type="radio" value="P" name="g2" id="p2" >P</input>

   <input type="radio" value="T" name="g2" id="t2" >T</input>

   <input type="radio" value="C" name="g2" id="c2" >C</input>

   <input type="radio" value="O" name="g2" id="o2" >O</input>
   </td></tr></table>
</body>
</html>

CognosAdmn · 04 Mar 2010 02:03:36 PM

-

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com

COGNOiSe.com - The IBM Cognos Community

News:

How can i carry forward values in crosstab?

shrini

shrini

CognosAdmn