I found this old unanswered thread.
Do you still need help with this?
(Note to self: V10.5 here)
yes it would be great if you can help me with this.
Thanks a lot for looking into it
thanks, for looking into it ,but if you see in my sheet im trying to show .
During Business plan what is the Sales Amt & Stock Amt
Particular month Forecast Sales Amt & Stock Amt
Forecast Sales Amt / BP Sales Amt similarly Forecast Stock amt -BP Stock Amt
the calculated field is ready if u download my workbook you can see it. only thing i need is different formatting
if Type=Sales then %
if type =Stock then standard format with 2 decimal
Because you want separate formatting, you'll have to make it a string calc. See [Calc vs BP Display].
I added it to the text box, so you can see how it works.
But because it's a string calc, we can't add it to the measure values shelf.
On copy (1) I changed the format of the text box to look like you see. That's one way to handle it.
On copy (2) I used a trick we have to format individual measures. Just put bogus sums on the sheet, and then individually display each item. This allows you to mix and match different formats (shapes for one column, text for another, bars for a third, etc.)
The one thing I could not get to work correctly was flipping the direction of the label for each axis. (Yes, each has a separate axis.)
The real key here is that you're going to have to format the special calc as a string.