1 Reply Latest reply: Nov 24, 2011 1:38 PM by seijsing RSS

    Pivot column sum + first sorted value problem

      Hi,

       

      I'm using the following expression in a pivot table in order to find the lastest test-result based on a choosen date, which works fine.

       

      Firstsortedvalue({<EXECUTION_DATE={"<=$(=max(Date))"}>} NoRunFlag, -RUN_ID)

       

      However, when choosing several dates the summarization in the pivot table does not work. Say that I have choosen 3 dates, and the flags all return 1, the pivot shows 1 as the column sum instead of 3. Any ideas on how to solve this?

       

      Thanks,

       

      Fredrik