total seems to be wrong

Options
Hexagon1
Hexagon1 Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

Hello Anaplanners

The result of the calculation seems to be wrong.

In fact is question 6 from model builder exam1.

the formula should return the sum of expenses based on hierarchical level and region, 

However, in my result, I only get the total displayed, independent which selection is applied.

I assume the the selection does not work as I might have missed some settings.

In fact it was mentioned in the lesson, 8.6.2, source has additional lists, which is I think is my issue, but I did not find the solution...😒.

Kind regards, Tutto.

 

 

 

Tagged:

Comments

  • Hexagon1
    Hexagon1 Member, ALL USERS Posts: 2 New Contributor

    I see, the EMP02 shows the values for the two dimensions, but cannot filter or distinguish them.

    Now having referenced to the SYS08 where the two dimensions are in, it actually work.

    Many thanks for the hint.

Categories