Scorcard Like Table

[#1]

Hello -

I am trying to create a scorecard based on a number of list box selections in the following format:

Metric	Selected Month	Change From Prior Month	Image
Some Rate	10%	+ 1%	Up Arrow
Another Rate	85%	-3.5 %	Down Arrow

I'm using a straight table chart and have a few questions about the best approach. Currently, I have expressions for each of the KPI's. I then use the "Horizontal" option to pivot the expressions to display as rows in the table.However, I'm unsure about how to add "Selected Month" , "Change from Prior Month", "Image" as the dimension members that will be displayed as columns.

An alternative approach might be to create a dummy table in my database that contains a list of Metrics. I could then use that table as my dimension and write three expressions. That said, based on the dimension member, the expression would need to do a different calculation.

IF(metric = 'Some Rate', sum(measurea / measureb), if(metric = 'Another Rate', sum(measurec / measured).........

I think this would work, but it isn't very clean. Please let me know if you have any suggestions. Thanks!

[avastani]

i am trying to do the same thing. any help would be appreciated. i tried using fieldvalue('dimensionname', rowno()) to retrieve the expression or it's value in this instance and no luck.

i know i am close but not close enough.