Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Statistics | 2011 | 2012 | 2013 YTD | 2013Q1 | 2013Q2 YTD |
---|---|---|---|---|---|
# of hours | 4,000 | 3,500 | 2,000 | 1,000 | 1,000 |
# of cases open | 1,000 | 1,200 | 900 | 400 | 500 |
# of cases closed | 800 | 1,000 | 300 | 100 | 200 |
# of issues | 200 | 200 | 600 | 300 | 300 |
Create a inline table with the field static_name. static_name column contain values # of hours, # of cases open ...
Then use dimension as static_name.
In expression you need to write expression like this
first expression for 2011
If (rowno()=1,
formula for hours,
if(rowno()=2,
formula for open cases,
if(rowno()=3,
formula for closed cases,
if(rowno()=4,
formula for issues))))
Thanks
Sibin jacob.c
Create a inline table with the field static_name. static_name column contain values # of hours, # of cases open ...
Then use dimension as static_name.
In expression you need to write expression like this
first expression for 2011
If (rowno()=1,
formula for hours,
if(rowno()=2,
formula for open cases,
if(rowno()=3,
formula for closed cases,
if(rowno()=4,
formula for issues))))
Thanks
Sibin jacob.c
What an elegance solution.
Thank you!