I'm trying to select a whole range in a nexel function

Jack Footer

The problem I am having is that in the Nexel I am using Range.Whole function in order to see the whole range. However because I have Sub Totals in my dataview ie. different Categories for SKUs it only takes the Range of that category as opposed to the whole column in the dataview.

 

Any help would be great!

Previous Member

Hi Jack Footer,

 

unfortunately the functions

• sorting
• column algorithm dt/gt
• nexel
• ranking function

seem to be having that limitation.

It looks like multiple row axis are implemented as "juxtaposition" of the lowest levels.

Using "flatten groups" does not help either.

 

If your axis entities are related, you could keep the most detailed one in the rows and display the others through Entities & Relationships in another column.

 

BR, Ray