I am using SAP design studio 1.6 and Bex query as a data source. I have a data source which has some measures, say A, B, C.
In Edit initial view of the data source (Design studio interface), I calculated sum (S) of the three measures (S = A + B + C). I did this by selecting the three provided measures, right clicking and using the “Add” function.
After this, I selected A and S , right clicked and selected “Percentage Share” to find the Percentage (P) of “A”. This gave me the percentage up to three decimal places. I want to set P up to one decimal place. When I right click P, there is no option of “Decimal Places”.
I have to display the P column” (Percentage of A) in a crosstab up to one Decimal place.
How can I achieve this? DO I need to write some scripts?
Please help. Any help will be greatly appreciated!!!