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.
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.