I`m working on how to get the output of the filtered total value in Column1 and Column 2 and show it in Column 3. Example for better understanding -
**Column 1 Column 2 Column 3 (calculation)** Complete period 1 1 Not Complete period 2 Complete period 3 1 Complete period 3 1 Not complete period 1
Column 3 to pull the total count of Column 1 with value set to Complete along with column 2 with value set to either Period 1 or Period 3.
I guess this can be achieved using Calculated column formula in Column 3. Please assist.