0 Replies Latest reply on Nov 13, 2014 6:41 AM by RickRobbins

    Interactive statistics on layout



      Interactive statistics on layout


      Hi, I am struggling with the following requirement:

      • I have a layout in which I would like to provide statistics on orders
      • The statistics are base on fields that the users populate, for example, they could enter a month and year in a "variable" and when the hit enter a script will run that will then display in another variable on the layout the number of orders for that month and the average amount. Another option is that they have a drop-down list for state which would then calculate the orders for that state and the average amount, etc.

      I just can't figure out an easy way to do this.  I don't want to add unnecessary fields to the DB or create a separate table as I don't need to store this information but I would like it to be interactive.  

      Any ideas on how I can do this????

      Many thanks in advance.