I am trying to create an expression as a calculated dimension within a pivot table. The table could have multiple PCPs listed but not selected and I'd like the expression to show an overall weighted avg value regardless of selection. I have tried using TOTAL and it works when a PCP is selected, but is aggregating all PCPs if multiple or none are selected.
I am wanting the calculation to show the overall score for each PCP regardless of selection. When I try that expression without the TOTAL it says error as a calculated dimension. It works as an expression in a straight table though.