I am relatively new to SAP BO, I am learning Design studio and my question is that I have two columns Column1 and Column2 and i am calculating 3rd column3 = (Column1+Column2)/100
Now i want to show this calculated value in the chart and crosstab. I do have multiple calculated columns which needs to be calculated on the fly and show in the chart and crosstab. Your help will be highly appreciated.
Note: i am using universe as my data source which is .unx
Any kind of calculation you can not do in Design Studio. You have to do it in Universe or BEx end. and then pull that field in your Charts or Cross Tab.