5 Replies Latest reply on Apr 2, 2018 2:30 PM by Ramin Melikov

    Trying to answer prep question - In which Region do all Product Sub-Categories fall beneath the overall average profit?

    Gabriel Flores

      This is the question:

      7. In which Region do all Product Sub-Categories fall beneath the overall average profit?
      a. All Regions
      b. Central
      c. East
      d. South
      e. West


      The answer is D according to the guide.


      I'm not even sure what it's asking. Is it asking which Regions do all avg profits of the Product Sub-Categories fall beneath the average profit for all regions?

       

      I suspect this requires LOD expressions (or possibly window_avg?) which I've attempted to do but with no luck. I've been at this for over two hours and could use some help. Still trying to understand when to use LOD vs WINDOW_AVG expressions.