Author Topic: Cross tab report  (Read 298 times)

Offline Vaib

  • Associate
  • **
  • Join Date: Dec 2017
  • Posts: 1
  • Forum Citizenship: +0/-0
Cross tab report
« on: 19 Dec 2017 04:52:22 am »
I am trying to make a cross tab report in which I needed top 10 values(at the intersection). After putting the summary filter for top 10, I now need sum of all the items including top 10.

I am unable to get the total since I've already applied a filter. I tried adding a data item and writing the query in it and changing its aggregation type to total, tried using a reference query. It still doesn't work. Any ideas that I can try???

Online Cognos_Jan2017

  • Statesman
  • ******
  • Join Date: Jan 2017
  • Posts: 333
  • Forum Citizenship: +2/-0
Re: Cross tab report
« Reply #1 on: 19 Dec 2017 01:02:23 pm »
Not sure I understand how you are running Totals.

We run Totals, in a Totals Row, and set ...
Detail Aggregation MUST be "Not Applicable"
Summary Aggregation MUST be "Calculated"

Let us know if that helps, Bob

Offline Nikhil Shenoy

  • Full Member
  • ***
  • Join Date: Sep 2017
  • Posts: 37
  • Forum Citizenship: +0/-0
Re: Cross tab report
« Reply #2 on: 08 Jan 2018 02:57:06 am »
Add a list table just below the cross tab (align it properly).
You can then unlock the list and add the "Value" in list. This will aggregate to the total of that measure and give in one cell.

Hope this helps!

Offline Pratap Reddy

  • Community Leader
  • *****
  • Join Date: Dec 2017
  • Posts: 116
  • Forum Citizenship: +0/-0
Re: Cross tab report
« Reply #3 on: 09 Jan 2018 05:09:49 am »
Hi,

Check the 'Automatically group and summary behavior for List.

Find the attachment.


 


       
Twittear