2 Replies Latest reply on Nov 15, 2018 5:03 PM by Deepak Rai

    can i find difference through table calculation.

    Pooja sharma

      Hi All! i am preparing for qualified exam and practicing some questions. I got correct answer for following question by table calculation but site shows different way. I used LOD calculation and used Fixed on region and then used differnce in table calc.  I would really appreciate your answers and opinion.. Thanks !!

       

      3. How much greater were the sales for the East region than for the South region?

      A. 1,597,346 B. 942,995 C. 825,458 D. 794,093 E. None of the above

       

       

      Screen Shot 2018-10-24 at 12.58.37 PM.png

      Screen Shot 2018-10-24 at 12.58.27 PM.png

       

      This is how i did it.. After using LOD expression  { FIXED [Region]: SUM([Sales])}

      Screen Shot 2018-10-24 at 12.48.06 PM.png