I have a pivot that consolidates a lot of information. In the end, I'm interested in two main flavors, EA and Non-EA: For each Program, Facility, and Description Type I need to take the EA amount and divide it by the sums of EA and Non-EA. For instance, in the Example, in Program IV-E, in "Child Placing Agency", we have Basic EA and Basic Non-EA, Intense EA and Intense Non-EA, etc. Out in Column H I have my tentative formula, which I'd like to be a calculated field in my pivot. I'm stuck with how to proceed from here.
To add a wrinkle, not every EA has a Non-EA. See the values I put in red. There we have 3 Non-EA fields, with no EA counterpart, so the resulting percentage should be Zero.
As I mentioned, I'm stuck at this point. Any help or advice would be greatly appreciated.
Thanks,
John
Bookmarks