Currently I am having trouble creating a dynamic table, be it straight or pivot. The data within my dimension is Finance Data.Metric. Under this heading lies an array of metrics that we will call Metric 1, Metric 2, .... Each Metric in the table has its own row, and thus own calculation, similar to the following:
| Metrics | Deviation |
| Finance.Metric 1 | 65.00 |
| Finance.Metric 2 | 4.00 |
| Finance.Metric 3 | 55.00 |
| Finance.Metric 4 | 4.00 |
| Finance.Metric 5 | 6.00 |
| |
When nothing is selected I need it to default to the current month, and further, instead of numbers, I want it to read as a symbol arrow facing upwards or downwards depending on its underlying value. So far I have the following:
Within my expression for deviation:
=IF(isnull(GetCurrentSelections([FiscalMonth])),
Sum({1<[Finance Data.Metric]={"*"}, [FiscalMonth]={'MAY'}>} [Finance Data.Deviation]),
Sum({$<[Finance Data.Metric]={"*"}>} [Finance Data.Deviation]> 0))
Within my the "show value" sub heading I have the following:
=IF(Sum({$<[Finance Data.Metric]={"*"}>} [Finance Data.Deviation])> 0,'▼','▲')
However, when nothing is selected it does indeed default to the values within MAY, but does not display the symbols as specified.
Any help, as always, is appreciated. Thanks in advance.
