Aggregation -> show / hide in NUX

Hi,

I'm trying to build all reports by using only NUX functionality and discovered that the items of lists / line item subsets change order when you hide / show some.

The parent / sum is shown at the top instead of at the bottom. In classic, I'm able to lock the order with show / hide.

Can this be fixed without building a saved view? I can imagine that this will frustrate end-users that want to build "My Pages" without a saved view.

/Philipp

Accepted answers

All comments

Misbah

@PhilippErkinger

Can you please share screenshot of what you mean here? As far as I know NUX display the list items exactly the way it was being done in classic.

PhilippErkinger

@Misbah absolutely. First picture shows the original Line Item subset with sum at the bottom. There is one item that I don't want to show in a report because it's only used to map / calculate. In classic, I'm able to select all items that should be visible and "show" keeps them in the same order. In NUX this doesn't work. It instantly switches so any summary is shown at the top.. no matter which child items are selected as shown (see second picture).

2020-05-13 17.00.27.png 2020-05-13 17.01.05.png

Misbah

@PhilippErkinger

Did a quick check and it seems to be working fine for me. Here are the snips

Before the Show/Hide on NUX

Change made

After Change

PhilippErkinger

@Misbah hmm... look again. You have the same problem: Total crew and admin is now shown at the top. The rest seems to miss a formula / aggregation. You will probably see the same when you add a total net result that sums gross profit and total crew and admin together.

Misbah

Oh yeah I see what you saying. This happens only when you have "Is Summary" enabled in blueprint mode.

Uncheck this boolean and parent will not be displayed at the top of the list

It has been explained well by David in his article. Line Item Subsets Demystified - Anaplan Community

Read final thoughts in the above article

Hope that helps

Misbah

PhilippErkinger

@Misbah Thanks for the article, but the problem is not only with line item subsets but with ALL lists that have a parent / summary / top-level. You can test the same with any hierarchies / list that have a summary / parent. The parents / summary items will be shown at the top and I'm not able to change that in NUX. This was simply possible with show / hide in classic and I'm wondering how it can be done in NUX without a saved view. Here is an example with a normal list:

2020-05-13 18.49.16.png 2020-05-13 18.49.01.png

Misbah

@PhilippErkinger

That's weird. I checked it and it indeed seems to change the positioning.Probably a bug here while using custom views. As far as I know there is no other to way to use Show/Hide on NUX. Can you please log a ticket with Support and see what they have to say. And please share the findings here - that would be great

sma328

Has this been addressed by the Anaplan team?

I am wondering if Anaplan could add the option to "Show all Subtotals at Bottom of Group" as the Excel pivot tables.

Our organization prefers to show parents, subtotals and totals at the bottom of the group. Everytime that a member of the hierarchy is added or removed to the report; the parents, subtotals and totals of the hierarchy automatically move from the bottom to the Top. We are having to manually re-organize them which is time consumming an tedious.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…