I am trying to add a calculated column to look at multiple variables from one column. I have tried normal pivot and adding the pivot to a data model. Here are the fields of my pivot.
Row - WBS Name
Column - Activity Status (Activity status has Not Started, In Progress, and Completed in the column values)
Values - Activity Count
I wrote a formula next to the pivot as IF(AND(B5="",C5=""),"Yes","No")). Column B is Not Started and Column C is In Progress. Is it even possible to to do a calculated field in a pivot to look at the 3 different values from the column name to write a formula like this ?
Row - WBS Name
Column - Activity Status (Activity status has Not Started, In Progress, and Completed in the column values)
Values - Activity Count
I wrote a formula next to the pivot as IF(AND(B5="",C5=""),"Yes","No")). Column B is Not Started and Column C is In Progress. Is it even possible to to do a calculated field in a pivot to look at the 3 different values from the column name to write a formula like this ?
