4 Replies Latest reply: Nov 6, 2015 11:52 AM by babacar sow RSS

    Data reduction

    babacar sow

      Hello Guys,

       

      Is there a way to reduce data by section access and to show all data on another field:

      ex:

       

       

      Section Access;

      Star is *;

       

       

      LOAD * INLINE

      [

      ACCESS,USERID,PASSWORD,AGENCE,YEAR

      ADMIN,AGBRT,toto,AGBRT,*

      USER,IDF,titi,IDF,*

      ];

       

      Section Application;

      Produit:

      load * inline

      [

      AGENCE,Produit,YEAR

      AGBRT,XXX,2014

      AGBRT,XXS,2015

      AGBRT,XXL,2013

      AGBRT,XZX,2011

      IDF,UUP,2014

      IDF,UUZP,2014

      IDF,UUSP,2012

      IDF,UUFP,2010

      ];

       

       

      Calendrier:

      load * inline

      [

      YEAR

      2010

      2011

      2012

      2013

      2014

      2015

      ];

       

      In this example i want to reduce data on AGENCE field but i want to show all YEAR even if i don't have data ?