Management Reporting: Hide Empty Columns

BenjaminNiel
BenjaminNiel
in Modeling

Hi Community,


In Management Reporting, I created a table with Line Items x Product Category:

image.png


I have the country as a selector but, for example, if I select a country where we don't sell "Performance" products, it still shows an empty column although I added a filter:

image.png

Do you know how to hide it so that, in this case, the table only has 4 columns?

Thanks for you help and please let me know if more info needed!

Benjamin

Tagged:

Comments

  • AjayM
    AjayM
    edited March 3

    Hi @BenjaminNiel ,

    I would ideally create a filter module, dimensioned by country and product category, with a boolean formatted lineitem. In this lineitem, you can either select applicable product categories for each country manually (as a one time backend setup or publish it on an admin page) OR preferably write a formula to check all lineitems for blank/zero values.

    Consider I have an input module dimensioned by Regions, Employee and couple of lineitems:

    image.png

    I created filter module by Region and Employee, to identify applicable employee for each region. I prefer separating filtering oriented lineitems into separate module, otherwise you can add these into input module itself if they are of same dimensions:

    image.png
    image.png
    image.png

    When I published input module to Management report, and added manual filter (for instance), you can see that employee dimension gets filtered as per my filter input:

    image.png
    image.png


    Hope this helps.


    Cheers!

Categories