I need to add a subtotal to this equation.
Goal is to create a dynamic count formula which will count the number of unique vales in a table column.
The SUBTOTAL column is the same as this Table2[DMA Rank],
So far I have this, subtotla part needs to be added.
=SUM(IF(FREQUENCY(Table2[DMA Rank],Table2[DMA Rank])>0,1))
Thanks,
Goal is to create a dynamic count formula which will count the number of unique vales in a table column.
The SUBTOTAL column is the same as this Table2[DMA Rank],
So far I have this, subtotla part needs to be added.
=SUM(IF(FREQUENCY(Table2[DMA Rank],Table2[DMA Rank])>0,1))
Thanks,