Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Relative Positioning on Shapes Changing Based on Resolution

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 crea...
Matrix Visual
shapes
subtotals
Icey's avatar
Icey
Community Support
4 years ago

Hi Anonymous ,

 

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's avatar
    Icey
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Can this meet your requirements?

     

     

    Best Regards,

    Icey

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.