Thanks for the response. The configuration of display does help, though are prefering to have the CREDIT LETTER viewed horizontally along side with other measures, In my sample table, have used only 3 additional measures, though in production, have anywhere from 15-25 additional measures being viewed at the same time.
To aid for the readability of the results, are methods/expressions that permit having the calculated field 'CREDIT LETTER' to appear as 'Measure' rather then a dimension, so that they could compared against other measures being analysed.
Thanks in advance, any feedback or suggestions are appreaciated.
Yep, I thought you might say that. I do not know of a way to combine measures & dimensions in the way you prefer them to be laid out. I'm not saying it CAN'T be done, I just don't know how. Sorry Ryan, someone else will need to assist you.
PS: You know Excel does these sorts of text tables extremely well, right?
Thanks for the suggestion. Found the Calculated Fields used to label the results are helpful.
Aiming to tighten the visual, does ability existe to create a Sample Table where the 'Credit Letter' ie: AAA stands alone like any other measure ?
Reason being, that the 'CREDIT LETTER' measure is distinct/viewed independently along side with other measures ie: Time to Maturity, Yeild, etc
MEASURE 2H4N 2Y22 153 154 199 200 414 442 469 470FI 475 476 TIME TO MATURITY 1.197 4.363 3.404 5.545 9.545 22.159 28.062 4.133 1.686 7.434 9.527 9.279 YTM 0.534 6.886 1.750 5.392 2.740 3.647 2.520 8.286 1.394 3.035 2.607 2.628 CREDIT LETTER AAA BBB AAA BBB AA AA AAA BBB AA A AA AA
HI Mark, Shawn;
Thank you both, contributions mark a great solution.
Love this forum, wish only that our IT, DB admins where 1/2 as productive.
Again thanks, this is going into production.