Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Is it possible that can we make a dimension from 3 differnt fields ?
Case :
I have table like this
ROW | Financial Year | Last 1 Year | Last 2 Year | Last 3 Year |
---|---|---|---|---|
1 | 2011-2012 | 2010-2011 | 2009-2010 | 2008-2009 |
2 | 2010-2011 | 2009-2010 | 2008-2009 | 2007-2008 |
3 | 2007-2008 | 2006-2007 | 2005-2006 | 2004-2005 |
On the selection of Financial Year 2011-2012 I want the Dimension of straight table will show last 3 year along with the selected year
Please guide me in this case or any workaround ASAP
Thanks & Regards
-anil
Hi Anil,
Can you please provide the required format in Excel
regards
Vijay
Dear Vijay,
Thanks for very quick reply,
please get attached excel of result required
-anil
You can use a set analysis.
Something like (for "Qty Total") : sum({$<Financial Year = {"<=$(=Financial Year)>=$(=Financial Year-2)"}>} Qty)
Of course, Financial Year should be a number else you can't easily do a -2 on it.
It will display in the chart 3 lines when you select only 1 Year in the list box
You could create a table in script which links every fiscal year to itself and last 3 years. Something like this:
Select Year | Year |
2011-2012 | 2011-2012 |
2011-2012 | 2010-2011 |
2011-2012 | 2009-2010 |
2011-2012 | 2008-2009 |
2010-2011 | 2010-2011 |
2010-2011 | 2009-2010 |
2010-2011 | 2008-2009 |
2010-2011 | 2007-2008 |
"Year" is the same field as the one in fact table and it links the two tables.
Use "Year" as table dimension, however make your selections on "Select Year".