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
Thanks Poovarasan.
This will be helpful.
But besides this, we have a requirement like (Measure A - (Measure B+ Measure C)) / No.of days in month
How this can be achieved. Measure A,B,C are coming from BEx query,
Thanks
Vaishali
Is this feature available in specific version of Design Studio. I am using DS 1.6 SP2, and on selecting two measures in Initial view of Data source , only remove option is coming. "Add Calculation" is not there.
Add comment