I can't seem to figure out where my mistake is. Did I miss adding a list within the hierarchy or is this simply an error within the blueprint?
In your blueprint (your 2nd picture), the line item summary is set to None.
Due to this, summaries will not happen which is why when you look at Americas, everything is blank.
I feel as though I'm making this more complicated that it is! I made the change (result photo one) and yet and still the data does not show results (photo three).
You need to enter your formulas and turn the summary back to None.
I was able to resolve the issue. I understand your reference to the Pivot now, there is where I had to switch G2 to Columns and Line Items to Rows! Thank you, again!
Change your pivot from Americas to a detailed member. Since your summaries (at the line item level) are turned off, data will not aggregate up.
@rob_marshall, I don't recall this being explained within the building instructions. Can you provide more detail on where this option is located?