It's me again, the dumbo asking active report questions :-S
I believe it is common to have KPI presented in dashboard. In Cognos report, the most common object used is called "Singleton" where a "text item" is embedded in it, and we can switch to use data item value. In active report, it seems impossible to filter/select a singleton, can anyone confirm this?
As an alternative, I switched to use "list" object, which seems to be the second most promising way. But a list shows multiple lines when multiple items are picked using active report checkbox. I tried hiding the categorical column using "box type" properties, made that column "hidden", remove the categorical column from the list and add into the list's properties, even played with the aggregation settings, but nothing works - still shows multiple line :(
Left with two not so decent options -
1) Change the font of the list to super small (0.1 pt) and do a total for the list with normal font
2) Attempt crosstab
Appreciate for any input :)