cancel
Showing results for 
Search instead for 
Did you mean: 

Quater(Q1)

Former Member
0 Kudos

HI Experts,

i am creating a report country,year, sales revenue.

country_______Year_______ sales revenue

A ___________2005 _______50000

B ___________2005 _______60000

C___________2005 ________70000

now create a variable and the formula is =Quarter([year]

i got report Q1 Q2 Q3 Q4 wise.

but i want to only Q1 report?

what i am do? help me..

Thank you ..

Accepted Solutions (0)

Answers (2)

Answers (2)

amrsalem1983
Active Contributor
0 Kudos

there is another quick solution

you can create a variable in the report itself using your fomula

and then you can apply a quick filter on the report over this new variable dimension

good luck

Former Member
0 Kudos

but i have this format(Year)

2004-10-23 00:00:00.00

2004-09-23 00:00:00.00

2004-08-23 00:00:00.00

2004-07-23 00:00:00.00

.

.

.

2004-01-23 00:00:00.00

How i get Quater(Q1)?????

Edited by: Praveen Vodela on Jan 28, 2011 10:13 AM

amrsalem1983
Active Contributor
0 Kudos

it ok, you can use this formula in your webi report

=Quarter(myDate)

good luck

Former Member
0 Kudos

thank you amr.!

amrsalem1983
Active Contributor
0 Kudos

did you solve it out?

amrsalem1983
Active Contributor
0 Kudos

in case you're creating a web intelligence report

click edit query

and drag the Quarter dimension to the query filter and restrict it to Q1

if you dont have the Quarter Dimension in the list of objects, then you have to create it at the universe level.

good luck