Management Reporting: Hide Empty Columns

BenjaminNiel · 2023-03-03T08:54:07+00:00

There was an error rendering this rich post.

Hi Community,

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

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:

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

Accepted answers

AjayM

Hope you can upvote this one, related to what you were looking for:

https://community.anaplan.com/discussion/155856/management-report-should-support-more-dynamic-layouts-e-g-filtering-on-columns-to-display

Cheers!

All comments

AjayM

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:

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:

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:

Hope this helps.

Cheers!

AjayM

Hope you can upvote this one, related to what you were looking for:

https://community.anaplan.com/discussion/155856/management-report-should-support-more-dynamic-layouts-e-g-filtering-on-columns-to-display

Cheers!

BenjaminNiel

Thanks @AjayM, indeed it's exactly the issue I have. I added my vote!

alexpavel

@BenjaminNiel, @AjayM : unfortunately, by design, the number of columns in management reporting pages is fixed. Until Anaplan will change this, we need to accept this limitation.

The filter works and shows the correct values of the columns, but always shows the same number of columns of the moment when the grid was published. If the filter would produce more columns, the additional columns will not be shown and if the filter shows fewer columns, the report will always show the blank columns.

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…