Filter multiple dimensions as rows
Im working on a rolling forecast module and have the following dimensions Versions (page), Time (columns) and Cost Centre, Gl and line items as rows. one of the line items is an input called temporary variance and a requirements is that across all time that the temporary variance sums to 0.
My problem is, I cannot figure out how to set up a filter that works on time, Cost centre and GL. Everything I try, if a cost centre has a non balancing variance, does not hide the GL's that are balancing. Below is a snip of some test data and my desired result.
Any assistance would be appreciated.