Chart Report-need Year and Quarter Information

[laxmanrao83]

Hi,

I have date column ,needs to diaplay in chart for all previos years like (2010,2011) should display in yearly
but for currect(latest) Year need to dispaly in quarter level like(2012Q1,2012Q2).


Pleae give response if you any solution

Please refer the attachemnt if you more infoemation

Thanks & Regards,
Laxman

[pricter]

Assuming that you r using  a relational pacakage you can create a
data item with the following expression

Code Select Expand

if ([Sales (query)].[Time].[Year]=2007) then ([Sales (query)].[Time].[Quarter]) else
(cast([Sales (query)].[Time].[Year],varchar(4)))

Replace 2007 with an expression that give the current year

[laxmanrao83]

hi ,

Thanks for reply
i don't have any dataitem for current year.

[pricter]

You can use cognos function current_timestamp

If you are using a ms sql server with

Code Select Expand

year(current_timestamp)

you get the current year.