Issue with Filtered Calculations in SAP WebBI

[hi-jrdn]

End Goal: Data Team puts report files as CSV at SFTP for outside visualization tool to utilize for a "live" dashboard. It has to come out of InfoView not our database. Due to technical limitations, ideally InfoView pre-calcs all values.

Intermediate Goal: Get this freaking table fixed. I'm burnt out. Example below. 

"Table" can be multiple tables but need to all have the same number of rows.

1. I need a column with the unique posting periods from all prior years. This will always be 01-12 and 14.
2. In the 2nd column for Period 01, I want to return SUM EXPENSE filtered by Period=01, Account=B01, Is Year=1. I want to divide that by the SUM BUDGET filtered by Account=B01 and Is Year=1. If Period doesn't exist for the year yet, return 0%.
3. In the last column for Period 01, I want to return SUM EXPENSE filtered by Period=01 and Is Year=0. I want to divide that by the SUM EXPENSE filtered by Is Year=0.

Somehow, I can do this in other tools using the same dataset. So I'm missing something.

What should these two formulas look like?