I am trying to blend two data sources. My two data sources have every dimension in common but different measures, I want to blend the measures using the dimensions in common.
In the packaged workbook attached, I have the first tab, "Total PPC", which successfully blends the two data sources and this is what I use to QA the rest. I need to get more granular (By Vendor) and segment these by "Account", but when I pull that dimension into the field and click the link (turning it on), the data I need disappears and/or if I don't click it, I get the same number across all segments, meaning the data is not blending correctly/not recognizing the "Account" dimension in the secondary data source.
To fix this, I attempted to create a calculated field in the secondary data source so that it would match the primary data source. I.e. Google, Bing, Yahoo Gemini. But my calculated field seems to be broken because while I tell it to look for anything with "google" or "Google" and name it "Google" (uppercase), or anything with "bing" or "Bing" and call it "Bing" (uppercase), it keeps it "google" and "bing" (lowercase) while only successfully creating the "Yahoo Gemini" segment. I can't seem to understand why this happening and I am pretty certain that this is the reason why the data is not getting divided properly. I am pretty sure this is the reason because you'll see that "Yahoo Gemini" does get populated with data while google and bing do not.
My main question is why my calculated field is not doing what I tell it to do?
My second question is if there is another reason why my data is not blending the way I need it to?