|
Re: Split the results in to Financial Quarters [message #876563 is a reply to message #876480] |
Thu, 24 May 2012 20:46 |
|
You could use a cube and crosstab to do this. Look at the attached
example. Be sure to update the datasource path.
You may also want to look at relative time period report item that is
described in this post.
http://birtworld.blogspot.com/2012/03/birt-372-new-features.html
Jason
On 5/24/2012 1:32 PM, A R wrote:
> Hi,
>
> I am working on a report which need to show the count based on year.
> Besides if the year is current year I need to split the results in to
> Financial quarters.
>
> Sample date with the count is as follows:
>
> ASSET_COUNT TARGET-DEPLOYMENT-DATE
> 5 5/31/12 12:00 AM
> 2 6/9/12 12:00 AM
> 2 5/17/12 12:00 AM
> 1 6/6/12 12:00 AM
> 1 5/25/12 12:00 AM
>
> Please let me if nay details required further.
>
>
> Thanks in advance
> AR
-
Attachment: xtabqtr.zip
(Size: 3.08KB, Downloaded 185 times)
|
|
|
Re: Split the results in to Financial Quarters [message #877089 is a reply to message #876563] |
Fri, 25 May 2012 21:18 |
A R Messages: 104 Registered: April 2012 |
Senior Member |
|
|
Hi Jason,
Thanks a ton. It was really helpful. Jason, can u please help me improve the logic further. Here if I have year is current year I need to show count in quarters and if YEAR IS prev year I need to show count for complete year.
If I want to show the values in chart, is there any alternative other than using script? Attached the sample screen shot, from excel report.
Thanks
AR
[Updated on: Fri, 25 May 2012 23:34] Report message to a moderator
|
|
|
|
Powered by
FUDForum. Page generated in 0.03591 seconds