I have a DMR model which I've created a cross tab report off of and 2 of the values in the measure are %'s (the rest are dollar values). Is there a way to format these as %'s separately from the rest of the dollar values? Also is there a way to recalc the totals for these %'s.
If you select the row or column heading for the percentage measure value, you can thrn right-click and choose "Select member fact cells". You can then set the format of the selected cells to be a percentage.
MF.