Hi Vaishali,
If your data source is from BW, then you can use Add calculation option in initial view of datasource for measures.
You can use Percentage Share option for your requirement.
Thanks,
Poovarasan
Hi vaishali,
You can do it in same way by creating multiple calculations in initial view as
1 . measure1=Measure B+ Measure C as first calculation
2 . measure2=Measure A-measure1 as second calculation
3. measure3=measure2/No.of days in month
For this you need to have No.of days in month as measure in your query.
Adding to that if you don't have No.of days in month in query while editing it you can simply add a formula to calculate it in query designer.
Thanks,
Poovarasan
Add comment