5 Replies Latest reply: Jun 15, 2017 8:30 AM by Thomas Le Gall RSS

    set analysis : sum total with criteria

    julien blanchard

      Dear all,

       

      I have a table with the following informations :

      - SITE NAME

      - WORKSHOP

      - TYPE OF PRODUCT

      - VOLUME

       

      The target shoud be to have on dimension : site name, workshop and type of product and to calculate :

      - the volume => ok it's easy : SUM(Volume)

      - the ratio : volume of final product of the site (i.e : TYPE OF PRODUCT=FINAL PRODUCT, in my example : 56 130) / volume

      => I have used this formula to calculate the total volume of final product by site :

      sum(total<[SITE NAME]>{<[TYPE OF PRODUCT]={'FINAL PRODUCT'},WORKSHOP=>}  [VOLUME])

       

      and... it works !

      Screen 1.PNG

      but... if I do a filter on the WORKSHOP dimension, workshops with final product are always displayed

      for example : with a filter on the workshop called 'MINE' only :

      Screen 2.PNG

       

      How can I change this formula to display only workshop that I've selected ?

       

      Thank you very much for your help !

       

      Regards,