Level 3 Sprint 1 5.2 TAR01 PY Country and Product Family Sales

erbaase

I'm trying to make a formula to sum the product sales by Country and Product Family. I've gotten the PY Account Revenue into the module and created list-formatted line items for Country and Product Family. Simply using PY Account Revenue[sum:Country, sum:Product Family] as well as the more complicated

PY Account Revenue[ sum: 'SYS03 Account>Product Details'.'G2 Country', sum: 'SYS03 Account>Product Details'.'P1 Product Family'], both yield a dimension mismatch.

I'm confused because what was the point of creating the SYS03 Account>Product Details module if I can't use it to map a SUM function by the details inside of it? It seems that the TAR01 module and SYS03 modules have the same dimensionality so it should just zipper in so to speak. I really don't understand what more Anaplan needs to do this SUM.

 

I believe I filled out the SYS03 module correctly, anyway:

 

The formulas that produced the above results:

The previously missing formulas yield the results I want (I think) but something must be wrong because I can't SUM based on country and product family.