locked
Filtering DVWP by Sum of Calculated Column RRS feed

  • Question

  • I have a DVWP for a MOSS 2007 list.  The DVWP is grouped by UserID, and has two calculated columns (AmtTot & MinTot). Each of these calculated columns sums two list columns (AmtTot=Amt1+Amt2, and MinTot=Min1+Min2).

     

    The two calculated columns AmtTot and MinTot are both totaled in a footer row.  What I now need to do is filter the list by the value of the footer row totals for these colunns, for each ID.  The filter criteria should be "where (AmtTot>=6000 OR MinTot>=150) AND Date>(Today-180 days)".

     

    I've tried to figure out how to filter using CAML and XSLT filter with no success...

     

    Help with a solution would be greatly appreciated!!

    • Moved by star.warsModerator Wednesday, November 23, 2011 2:18 AM Customization question (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    Monday, November 21, 2011 5:04 PM