2 Replies Latest reply on Jul 13, 2018 1:21 AM by AJ.Yusuf

    Lookup with a possible LOD

    AJ.Yusuf

      Hi All,

       

      Hope you are well. I am looking at the first pic below. I am using a lookup formula (Sales with QC) to get the previous day value for the current day on a daily view. These numbers are correct!

       

      However I just want to show a sum of these numbers in a weekly view (Pic 2) but it doesnt work, I understand becuase it just looking at the prev value on a weekly basis now.

       

      How do sum to get the correct result as shown in pic 2?

       

      thanks

       

       

      Pic 1

       

       

       

      Pic 2

       

        • 1. Re: Lookup with a possible LOD
          swaroop.gantela

          AJ,

           

          I think there may be a few more steps needed to get the weekly sum.


          I think you will need to have the Day on the Detail shelf.

          Then, I think you can just use a WINDOW_SUM([Sales without QC]).

           

          The next part will be the Table Calculation settings (as shown in the screenshot below).


          Lastly, there are multiple copies of the value (because of putting the Day on the detail shelf)

          but this can be filtered down to one value by putting Index on the filter shelf,

          making it's table calc settings the same as above, and filtering to one.

           

          Please see the workbook attached in the Forum Thread.

           

          275384sum2.png

           

          275384sum.png

          • 2. Re: Lookup with a possible LOD
            AJ.Yusuf

            Hi Swaroop,

             

            Thanks for your help

             

            I have tired to this but a bit confised I am tryinh get this into a weekly view but with the correct numbers added. i have a attached TWBX file for your reference