0 Replies Latest reply: Mar 26, 2012 8:47 AM by Gemeente Breda RSS

    showing the actual value of a field

    Gemeente Breda

      Dear QV-user,

       

      I am in need of help to solve a problem in one of my QV-charts.

       

      In my chart I would like to show the date below.

       

      10-10-2011          Dave     London Office     Finance department     10

      10-01-2011          Jane     London Office     IT department              12

      10-01-2012          Dave     Paris Office        Sales department        20     <= Current Value Paris Office, Sales department

          

      and I would like to see this:

       

      NameOfficeDepartmentDateValue
      DaveParis OfficeSales department10-10-201110
      10-01-201220
      JaneLondon OfficeIT department10-01-201112
      Total42

       

      The formula I was thinking of was

       

      =Only({$<Jaar = {'$(=YEAR(Today()'}>} Afdeling.Niveau2)

       

      This does not seem to work.

       

      Anyone got a solution?