Thank you so much for providing the solution to p3, yet why can’t I solve it by:
1. introducing LOD { FIXED [Product Name]: sum([Profit])}? Or,
2. simply create “TOP 10 profitable products 2012” using create sets from “Top” conditions from the “Create Set” dialogue?
Both approaches will return the answer of 134981 which is obviously wrong? But I still see the Measure Values on the shelf as “Sum(Profit)”, getting confused for when to use this list set creation and when to use the dialogue window to do so.
I think this quiz has only a solution guide for question 3, as you can see after you click submit. Do you need for one of the other questions a solution guide? Maybe I can explain them here.
Thank you so much for providing the solution to p3, yet why can’t I solve it by:
1. introducing LOD { FIXED [Product Name]: sum([Profit])}? Or,
2. simply create “TOP 10 profitable products 2012” using create sets from “Top” conditions from the “Create Set” dialogue?
Both approaches will return the answer of 134981 which is obviously wrong? But I still see the Measure Values on the shelf as “Sum(Profit)”, getting confused for when to use this list set creation and when to use the dialogue window to do so.
For Solution 3
Simple need to set Year(Order Date):2012 as Context Filter then we can get right answer.
What is the solution set for this?
Hi John,
I think this quiz has only a solution guide for question 3, as you can see after you click submit. Do you need for one of the other questions a solution guide? Maybe I can explain them here.
Thank you,
Narcis