Topic
  • 3 replies
  • Latest Post - ‏2018-08-14T14:08:31Z by G. Lohwasser
Obwan
Obwan
2 Posts

Pinned topic Crosstab Row Totals Cognos Analytics 11

‏2018-08-12T21:13:07Z |

The report I am trying to create is very simple.

Vertical drop Zone = CUSTOMER

Horizontal Drop Zone - top Row Last Month (LMTY) and Last Month Prior Year (LMLY)

Horizontal Drop Zone - row 2 - Units and Revenue

Calculation - Row Variance between LMTY Units and LMLY Units and the same with revenue.

Issue: When I click Units - Units it appears to calculate but nothing is returned.

I have tried using the Variance option on  Total Icon and the Units - Units from the Calculation icon.

Nothing works.

If I remove say the units and only have revenue the calculation works but I want both,

I want to end up with

Units and Revenue (LMTY) Units and Revenue (LMLY), Unit Variance TMTY - LMLY and Revenue Variance LMTY - LMLY

I maybe a novice with Cognos but it sounds so simple.  My work around is to export to excel.   

I have to say I feel really dumb asking this because it seems so straightforward.  I cannot get it work and have no one to ask.

Thank you in advance.

Updated on 2018-08-13T03:13:47Z at 2018-08-13T03:13:47Z by Obwan
  • Obwan
    Obwan
    2 Posts
    ACCEPTED ANSWER

    Re: Crosstab Row Totals Cognos Analytics 11

    ‏2018-08-13T18:47:54Z  

    Had a look and cannot see immediately how to post a questions.   Thank you for letting me know I am in the wrong place.  

  • G. Lohwasser
    G. Lohwasser
    59 Posts

    Re: Crosstab Row Totals Cognos Analytics 11

    ‏2018-08-13T08:06:46Z  

    Please post your question in the IBM Cognos Analytics (v11.x) forum: https://www.ibm.com/mysupport/s/topic/0TO500000002PVJGA2/cognos-analytics-formerly-cognos-business-intelligence?language=en_US&productId=01t50000004XdwrAAC

  • Obwan
    Obwan
    2 Posts

    Re: Crosstab Row Totals Cognos Analytics 11

    ‏2018-08-13T18:47:54Z  

    Had a look and cannot see immediately how to post a questions.   Thank you for letting me know I am in the wrong place.  

  • G. Lohwasser
    G. Lohwasser
    59 Posts

    Re: Crosstab Row Totals Cognos Analytics 11

    ‏2018-08-14T14:08:31Z  
    • Obwan
    • ‏2018-08-13T18:47:54Z

    Had a look and cannot see immediately how to post a questions.   Thank you for letting me know I am in the wrong place.  

    You need to sign in to the community to be able to ask a question. There are corresponding links on the page.