COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: shrini on 12 Feb 2010 01:16:24 PM

Title: How can i carry forward values in crosstab?
Post by: shrini on 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
Title: Re: How can i carry forward values in crosstab?
Post by: shrini on 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>
Title: Re: How can i carry forward values in crosstab?
Post by: CognosAdmn on 04 Mar 2010 02:03:36 PM
-