Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to know small thing I have chart like below.
In dimension i have QuarterYear.In below chart I want to remove Q1 11, Q2 11, Q3 11, Q4 11.
How to remove only those .
send that qvw file it would be better
depending of your dateformat you shoud use a calculated Dimension
dateformat
if (year(yourquarterfield) > 2011, yourquarterfield)
stringformat
if (right(yourquarterfield,2) <> '11,yourquarterfield)
First thing, its not clear what you want to remove, Q1 or 11??
If you want to remove 11 from Q1
then try:
mid(QuarterYear,1,2) as QuarterYear // it wud give you Q1
The easiest way is to select the other values. If you want to do that only to this chart and not other charts in your document you can modify your expressions to exclude these specific values. For example Sum(Sales) would become Sum({<QuarterYear -= {'Q1 11','Q2 11','Q3 11','Q4 11'}>}Sales).
Hi,
another solution could be:
=Sum({$<QuarterYear={"=Year(QuarterYear)>2011"}>} Value)
hope this helps
regards
Marco