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

# Including 1 column of another measure

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.

• ###### 1. Re: Including 1 column of another measure

Hi Kelly,

if possible, please provide some sample workbook.

instead of using FIXED, use INCLUDE

{INCLUDE : SUM([UNITS ON HAND])}

Thanks,

Sreekanth.

• ###### 2. Re: Including 1 column of another measure

Hi Kelly,

Maybe a table calc like LOOKUP(SUM([Units On Hand]),LAST()) will do the trick.

Regards,

Ivan