Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

create a Measure based on filtering database for each item

Hi community,   I have a database with list of project/company and activity and I would like to make a measure that count the qty of projects with the same company and activity as below table .   ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

table in different format 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    to clarify the result of the table:

    line 1: qty of projects with company1 and activity1=2

    line 2: qty of projects with company1 and activity2=1

    line 3: qty of projects with company2 and activity1=3

     

    ...

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Community 

     

    I m just following up on this request

     

    anyone have any idea on how to adress this issue

     

    thank you for your support