8 Replies Latest reply: Nov 7, 2014 12:12 AM by Ronny Wroblewski RSS

    Problems with a matrix (parallel sale of different items)

    Ronny Wroblewski

      Dear Community

       

      I try to create a matrix, which should show the percentage of sales (e.g. Category A & B items) / sales (e.g. Category A)

      I have a bill no. field which is connected to the item categorie field and I try to create a straight table where I use the Category field as dimension and a formula for each column.

       

      Example.PNG.png

       

      My problem is how can I use Aggr function to count only bill no. which include both categories.

       

      I tried something like Aggr ???  / Count(Distinct {$<CATEGORY={'A'}>} BILLNO) *100 but I couldn't find a solution.

      If someone has an idea or advice please let me know.

       

      Best regards,

      Ronny