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

Jack Footer
Jack Footer Active Partner
Fourth Anniversary 25 Up Votes First Comment
in Platform

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!

Answers

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    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

Categories