on 01-25-2011 7:11 AM
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 ..
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.