Author Topic: Multi-line, Multi-Measure Crosstabs  (Read 548 times)

Offline RickGardner

  • Associate
  • **
  • Posts: 2
  • Forum Citizenship: +0/-0
Multi-line, Multi-Measure Crosstabs
« on: 19 Apr 2009 05:41:15 am »
I am trying to build a sales and profit report as follows:
  • Years across the top (DMR hierarchy with drill-down)
  • Product Group as the Row Hierarchy (again, drillable)
  • Each row to contain three measures, organized verically (three sub-rows): Sales, Cost, Profit

Is this a possibility with Cognos 8.3 or 8.4? Another option I am looking at is to create a special reporting file that has different records for each of the lines, but this is more complicated that I prefer to get!

Thanks

Offline njz

  • Associate
  • **
  • Posts: 1
  • Forum Citizenship: +0/-0
Re: Multi-line, Multi-Measure Crosstabs
« Reply #1 on: 27 Jul 2009 11:15:53 pm »
I'm trying to do the same thing without any luck ... did you figure out a solution?