IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2013-12-03T18:13:15Z by OpherB
sri_123
sri_123
2 Posts

Pinned topic display different set of values in same rows in crosstab

‏2013-11-28T11:51:43Z |

Hi,

We are currently working on a DMR model. We have a crosstab which has months in rows and columns where the measure displays in different rows for different years as in attachment. We are trying to  combine the measure values, display one set of columns and then another set using the same rows. Please let me know how this can be acheived.

 

Attachments

  • OpherB
    OpherB
    664 Posts

    Re: display different set of values in same rows in crosstab

    ‏2013-12-02T21:47:37Z  

    I believe you are trying to create a discontinuous crosstab. Here is an example: https://www.ibm.com/developerworks/community/forums/html/topic?id=9e0ac285-01f1-44dd-bcac-39d9ed74522e&ps=25

    Good luck,
    Opher

     

  • sri_123
    sri_123
    2 Posts

    Re: display different set of values in same rows in crosstab

    ‏2013-12-03T10:08:50Z  
    • OpherB
    • ‏2013-12-02T21:47:37Z

    I believe you are trying to create a discontinuous crosstab. Here is an example: https://www.ibm.com/developerworks/community/forums/html/topic?id=9e0ac285-01f1-44dd-bcac-39d9ed74522e&ps=25

    Good luck,
    Opher

     

    Hi,

    The link redirects to the same page.

    But we could acheive this by making some changes in the model. Thanks a lot.

     

    Regards,

    Sri

    Updated on 2013-12-03T10:09:23Z at 2013-12-03T10:09:23Z by sri_123
  • OpherB
    OpherB
    664 Posts

    Re: display different set of values in same rows in crosstab

    ‏2013-12-03T18:13:15Z  
    • sri_123
    • ‏2013-12-03T10:08:50Z

    Hi,

    The link redirects to the same page.

    But we could acheive this by making some changes in the model. Thanks a lot.

     

    Regards,

    Sri

    Sorry about the link. Here is the correct one: http://pic.dhe.ibm.com/infocenter/cbi/v10r2m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.0.doc%2Ft_cr_rptstd_reptyp_discontinuous_crosstab.html

    Good luck,
    Opher