Decimals in Analysis Charts
i have the problem that for datasources/crosstabs that contain values which never have decimal places still show decimals in the chart component of analysis. The values that i mean here are those that are displaed when you hover over for example one bar in a bar chart. This can however be fixed if you use the excel function to change the cell type to "text" but after refreshing the datasource this is overwritten again. Is there a possibilty to set this for the chart/crosstab/datasource fixed? So that it would never show decimals?
Thanks in advance for your help!
Dominik Herrmann replied
Ok i think i found the problem the format that is handed over to Excel by Analysis is defined in the format set (SAP Blue or SAP Styles etc.). If i export one of those as XML i can change the decimals for "SAPDataCell" in the file and reupload that with a different name. If i then use this format set in my Workbook the graphic shows no more decimals.
Thanks for your quick replies Tammy.