Hi
Not sure if this is the right forum but I will give it a try anyway.
I need to create both a table and a char with an index that is locked to this year and this year and last 6 months.
I have created the table and the chart and they shows the data but if I change year mye table and chart also changes.
I need for them to be locked no matter what I do in my other selections.
My calculated expression:
(
(
sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} CountOfResults)-
sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} OutOfLimit)-
sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} OutOfOuterLimit)
)/
sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} CountOfResults)
)*100
Aar = year
Mnd = month
If I set a conditional calculation in my general tab it will only show 2011 figures, but of course only when I select 2011 from my year selection box.
Ideas anyone?
Hope to hear from you.
Dan