Management Report : Hide Blank columns

tompatrick.ting
tompatrick.ting
edited December 2022 in User Experience

Hi,

 

How to hide the sync time period that are blank in my Management reporting ?

tompatrickting_0-1670813979134.png

tompatrickting_1-1670813991566.png

 

 

Thanks in advance for helping.

Tom

Tagged:

Answers

  • Lehtohen
    Lehtohen
    edited December 2022

    Hello, 

    You can use a filter to hide blank values. 

    Starting Situation:

    Sieppaa.PNG

     

    Step 1: Add a filter to columns to hide 0 values

    Sieppaa2.PNG

     

    End Situation:

    Sieppaa3.PNG

     

    In case you have multiple line items you can create a support line item called "filter amount", which is the sum of all absolute values. 

    For example "Filter Item = ABS(Item1) + ABS(Item2) + ABS(Item3)" and then use that for filtering. Now months where only one line item would not equal 0 would still be visible. 

     

  • tompatrick.ting
    tompatrick.ting

    Thanks @Lehtohen  for commenting.

     

    Applying filter would not work as there are data in my future quarter.

     

    They are blank because i enables the Time Sync and Hierarchy filter.

    tompatrickting_0-1670837576576.png

     

Categories