2 of 2 people found this helpful
I created 3 calculated fields based on the way you filtered those three sheets. Then it is just a matter of adding measure values to text and measure names to your column shelf. No filters needed for the stage. I did filter measure names on just the three you wanted in your view.
IF [Stage] <> 0 THEN [Amount] END
IF [Stage] = 0 THEN [Amount] END
IF [Stage] = 10 THEN [Amount] END
9.2 workbook attached.
1 of 1 people found this helpful
Create calculated fields for them and then use them in one worksheet. if your calculated filed falls into measure then you can use measure values option.