You can either Join your datasources or do blending on some common field and can do calculations. For joining use Cross data base join between SQL DB and EXcel on common field.
Here is It:
For Blending, Use this:
Thanks! But my problem is that I do not have a common field between the two sources? What would be a way to do the calculation then?
Thanks but I’m on 10v1 unfortunately so I can’t take a look. Can we create a calculation?
In that case you need to add a Column to both your data sources which should have a value of 1 only across all rows . Then you can join...Cumbersome but works...
Thank you for your time. But this is not an option as I don’t have access to modify the SQL datasource ;-(
Virginie D. Bocard
ITSCS – Program, Initiatives & Analytics Team
Respectful Workplace Advisor for ITS
T +1 (202) 473-9665
1818 H Street, NW; Washington, DC, 20433
Questions on RWA’s role? Click for more information<http://spcapps.worldbank.org/sites/IJS/SitePages/RespectfulWorkAdvisor.aspx>
Just to clarify. I do not have a common field nor cannot add one to the SQL data source. Would it be possible then to write a formula that would say something like that:
if assigned group = AFR then sum and divide by 62
if assigned group = EAP then sum and divide by 43 etc. ?
Also would it be possible to graph the results of the calculation?
Thank you for your input.
You can do anything if you have data in one place...These are disjointed sources...won't work alone what you are looking for...