Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Countifs for each specific value

Dear friends

 

how can i create calculated column that shown no. of rows that contain values or text in column for each specific reference number

Example.

Ref. numberValuescalculate column
1111a2
1111b2
1111  
2222c1
2222  
3333b1
3333  

 

thanks in advance for any suggestions

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a new column like

    countx(filter(Table, [Ref. number] =earlier([Ref. number]) && not(isblank([Values]))),[Values])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Create a new column like

    countx(filter(Table, [Ref. number] =earlier([Ref. number]) && not(isblank([Values]))),[Values])