5 Replies Latest reply on Feb 25, 2016 12:55 AM by adrian.pellegrini

    How could I filter numerator and denominator of a ratio quite separately

    adrian.pellegrini

      Hi everyone,

       

      I have a problematic with a database.

       

      The question is : how could I filter numerator and denominator of a ratio quite separately?

       

      Please find attached Excel file and workbook.   

       

      I want to get three views :

       

      The one on the left is filtered by "Where" and "Produit"

      The second one on the right must be filtered by "Produit" only

      And the rate is the mix of both :

      - Numerator : filtered by "Produit" only

      - Denominator : filtered by "Where" and "Produit"

       

      I have tried something (attached workbook) with duplicated datasources, but even when I link the two datasources only by "Produit", the where change the two fields.

      I understand why it is not working but I do not have any solution at the first problematic.

       

      Do you have a solution or idea ?

       

      Many thanks,

      Adrian