Display % in X axis for Bar Chart

[former_member745330]

ello SAC Experts

SAC chart should contain Target values vs Actual values(triangle symbol).

But, my axis should display in %.

For Example 18,000 value is 100% and the my actual is around 5%. this has to be displayed in bar chart(attached).

I have chosen this chart as I did not find this representation in any other chart. Kindly advise the possibilities.

Vijay

[miquelfornieles]

Hello Vijay,

There are already similar questions.

You can create a calculation and use formula %GrandTotal()

%GrandTotal(Account)Returns the percentage of the grand total that each value represents.

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/3b7c99a7a7cd4a29bb1c5132d...

Regards,

Miquel

[former_member745330]

Hello Miquel

I tried to use this in a calculated column but i see below error.

The function "%GRANDTOTAL" cannot be used in the formula as it is not supported by the system.

So, I tried to write the same logic at Model level but still the same Error.

Now, I have created this logic in source(hana views), but now i atleast want % to be padded up after the value. Not sure how to do it.

Please advise.