|Show Last Month Of Quarter! [message #1746893]
||Mon, 07 November 2016 12:03
| Devpriyo Bhattacharya
Registered: October 2016
I am using BIRT Designer 4.2.1 and 4.6. I have my data as follows:
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
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
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.
Powered by FUDForum
. Page generated in 0.02174 seconds