2 Replies Latest reply on Oct 21, 2016 10:53 PM by Ivan Young

    Including 1 column of another measure

    kelly.schmittel

      In the below worksheet I would like to maintain the 6 date columns of Units Sold, but only show the results of 'Units on Hand' for the week of October 16th. I have been unable to figure this out. I tried to do a LOD fixed calc and almost got it but was getting the wrong result. I'm not even sure if a fixed calc would work? Any help would be appreciated.

       

       

      When I tried Fixed LOD

       

      { FIXED [Location ID], [AccountDateSelect]: sum([Units on Hand])}

      The result for Location ID 47 for 'Latest Units On Hand' should equal '10' which is the On Hand amount for October 16th for that location.