Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Show Last Month Of Quarter!
Show Last Month Of Quarter! [message #1746893] Mon, 07 November 2016 12:03
Devpriyo Bhattacharya is currently offline Devpriyo BhattacharyaFriend
Messages: 12
Registered: October 2016
Junior Member
Hi All,

I am using BIRT Designer 4.2.1 and 4.6. I have my data as follows:

Year: 2015
Month: Jan, Feb, Mar, Apr, May, Jun, Jul and Aug (8 months of data)
Quarters: Q12015, Q22015 and Q32015
Measures: No. of Accounts

Month No. of Accounts
Jan 10
Feb 20
Mar 30
Apr 60
May 120
Jun 240
Jul 480
Aug 960

Last month for Q1 2015 = Mar
Last month for Q2 2015 = Jun
Last month for Q3 2015 = Aug (Since Sept is not present)

Now, my requirement is such that, when I select Quarter, I shall get the below table:

Quarter No. of Accounts
Q12015 30
Q22015 240
Q32015 960

Note: Only the last month of the quarter values are showing in the table.

In Cognos, I have used,
within set tail(filter(descendants(currentMember(...function

In Tableau, I have used Fixed function.

I now want to achieve the same in BIRT.

Best Regards.
Previous Topic:How to Use Named Parameters in Dataset Query ?
Next Topic:Sample example for birt report generation
Goto Forum:

Current Time: Tue Sep 29 01:39:02 GMT 2020

Powered by FUDForum. Page generated in 0.01797 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top