Relative Positioning on Shapes Changing Based on Resolution

[jacobfrp]

I'm trying to create a sort of dynamic PNL using the basic matrix visualization. The issue is that I want subtotals for each of the bolded catergories, and then a grand total (Net Income).  I've created a matrix that functions properly, but there are extra lines of data that repeat catergory sums. In order to negate this issue, I placed grey shapes over the unwanted rows to hide them. The issue is that when I view the report on screens of different resolutions, the shapes move slightly. This movement will cause the shapes to be covering the wrong rows of data.

Is there any way to either A) lock the shapes in place relative to the matrix or B) insert custom subtotal rows in a matrix? 

Attached is a screenshot of the first column of this matrix, with the shapes in place below "Total Utilities" and "Taxes & Insurance"

[Icey]

Hi @jacobfrp ,

How about hiding unused rows based on expression and Visibility section? And here is an example: How to Hide Unused Rows in a Tablix | Ask Garth.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Icey]

Hi @jacobfrp ,

Can this meet your requirements?

Best Regards,

Icey

[jacobfrp]

The way it is currently organized, no. The problem is that the individual items are grouped into different categories as follows:

1. NOI

    2.CNOI

        1.EGI

         2.Controllable Expenses

    2. (Blank)

        3. Non-Controllable Expenses

2.(Blank)

    2. (Blank)

    4. Non-operating Expenses

It is organized as such because of the specific subtotals that I need included. I want to get rid of all of the rows that say (blank) but still keep their place in the hierarchy.