This is the point where I think you need to go back and revisit your data modeling. At this point, you’ve now got two versions of your fact table to work with: the original, and the unpivoted version. I think the next step is for you to construct your dimension tables (e.g., Subject, Period, Building, etc.) and connect those appropriately to your fact tables, so that your slicer fields come from your dimension tables and not your fact tables.
When constructed this way, I think you can get all the information you need by choosing the appropriate version of your fact table and slicing it/filtering it/aggregating it as needed.
Give it a go, and give a shout if you run into any problems.
I’ve attached a cleaned up version of the solution file, since the idiotic “autodetect relationships” feature had linked the two fact tables in its typical nonsensical way…
– Brian