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.
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.