Jump to content

BIRT Developer Center Download


Photo
- - - - -

Grouping Crosstabs

Crosstab Grouping

  • Please log in to reply
8 replies to this topic

#1 sidrees

sidrees

    Advanced Member

  • Members
  • PipPipPip
  • 39 posts

Posted 13 April 2016 - 07:43 AM

Hi,

I am working on crosstabs where user selects one or more companies and in crosstab sums up the figures for all companies and displays in the columns which is fine,

 

Is there any way to draw the a separate crosstab for company?
Please see the attached picture to understand the requirement,

Attached File  Birt - Grouping Crosstabs.png   162.07KB   1 downloads

Thanks in advance!
 



#2 Clement Wong

Clement Wong

    Senior Member

  • BIRT Experts
  • 1204 posts

Posted 13 April 2016 - 08:23 AM

You'll need an outer table that lists all of the companies.

 

Then in the detail row, you can add the cross tab.   Next, apply Filter to the cross tab that defines where company = current company row value.


Clement Wong
Principal Analytics Architect

OpenText Corporation
http://www.actuate.com | http://www.opentext.com


#3 sidrees

sidrees

    Advanced Member

  • Members
  • PipPipPip
  • 39 posts

Posted 13 April 2016 - 08:28 AM

I got it, thank you very much!



#4 sidrees

sidrees

    Advanced Member

  • Members
  • PipPipPip
  • 39 posts

Posted 14 April 2016 - 04:00 AM

Hi,

Can you please suggest how can I achieve the following,
I need to calculate the figures for Fiscal Years and not for the Calendar Years,

  • Example: For Fiscal year Jul 2008 - June 2009. The formula would be (Jul 1, 2008 to Dec 31, 2008) + (Jan 1, 2009 to June 30, 2009) = Values-2008 / 2 + Values-2009 /2, and show the result under year 2009 column

Attached File  Screen Shot 2016-04-14 at 1.55.07 PM.png   189.9KB   0 downloads

 



#5 sidrees

sidrees

    Advanced Member

  • Members
  • PipPipPip
  • 39 posts

Posted 14 April 2016 - 04:59 AM

Any idea if "Relative Time Period Aggregation Builder" will solve what I am looking for?
I do not know how to use it.



#6 shamo

shamo

    Senior Member

  • Members
  • 190 posts

Posted 14 April 2016 - 05:27 AM

what I will do is to have a computed column defining your Fiscal years and use an if condition for computation based on which fiscal year your are on. When I had to do something like this, I didn't use  crosstab table but created a crosstab from straight table. when you do that, there is flexibility in computations.



#7 sidrees

sidrees

    Advanced Member

  • Members
  • PipPipPip
  • 39 posts

Posted 14 April 2016 - 09:12 AM

I am able to use Relative Time Period Aggregation

Attached File  Screen Shot 2016-04-14 at 8.52.17 PM.png   67KB   0 downloads

 

and added a data binding to get the desired result,

 

but now I am unable to add GrandTotal for my calculated value, any idea if I am misusing something?
Attached File  Screen Shot 2016-04-14 at 9.59.42 PM.png   92KB   1 downloads

 



#8 sidrees

sidrees

    Advanced Member

  • Members
  • PipPipPip
  • 39 posts

Posted 16 April 2016 - 03:52 AM

This post helped me
http://developer.act...d-total-column/



#9 nvkumar

nvkumar

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 13 September 2017 - 11:28 AM

Can anybody please provide sample design file for above report desgin







Also tagged with one or more of these keywords: Crosstab, Grouping