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. number Values calculate column...
  • amitchandak's avatar
    5 years ago

    Anonymous , Create a new column like

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