8 Replies Latest reply: Mar 23, 2018 5:10 AM by Jonathan Dienst RSS

    Aggregation with set analysis

    Christoph Albrecht

      I have the following base data table:

       

      DateCol1Col2Col3
      Date11A-
      Date2-A-
      Date21-Q-
      Date3-AX
      Date42B-
      Date5-BX
      Date63CX
      Date7-C-
      Date84D-
      Date95E-
      Date10-E-
      Date116F-
      Date12-FX
      Date13-FX
      Date131-PX
      Date14-F-

       

      Now I want to count the text values at Col3 based on aggregation of Col2. Thw result should be the following table:

       

      DateCol1Col2newCol
      Date11A1
      Date42B1
      Date63C1
      Date84D0
      Date95E0
      Date116F2

       

      To get Date, Col1 and Col2 I can simply filter Date, where Col1 is not null. Or I use directly a filter for Col1. But how can I count the text values at Col3, when I filtered the Date before? I thought of something with set analysis.

       

      Does anyone have an idea?

       

      BR

       

      Nachricht geändert durch Christoph Albrecht