Formatting Single Column (Total Year) but Key Figures have different formatting of values

[former_member862651]

Hello,

I have found a way to format a single column (as seen in the picture, only the total year has been formatted). However, I would like my total gross profit (%) to show as % and not as absolute values. How can I format just this Key Figure in this column?

[moshenaveh]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[guglanigaurav1987]

Hi Eva,

You can achieve the same by making use of IBPFormattingSheet available in the Excel PlugIn.

Refer help document here for detailed steps.

Thanks

Gaurav