In configure layout of data-view, I have taken cubes with required dimension and the entity on which I want to apply filtering and sorting. For sorting, I am using the algorithm - IF(p="105",1,0)+IF(p="110",2,0)+IF(p="120",3,0)+IF(p="130",4,0)+IF(p="140",5,0)+IF(p="150",6,0)+IF(p="160",7,0)+IF(p="170",8,0)+IF(p="180",9,0)+IF(p="190",10,0)+IF(p="310",11,0)+IF(p="400",12,0)+IF(p="220",13,0)+IF(p="230",14,0)+IF(p="210",15,0)+IF(p="240",16,0)+IF(p="250",17,0)+IF(p="260",18,0)+IF(p="270",19,0)+IF(p="280",20,0)+IF(p="290",21,0)+IF(p="300",22,0)
Now in row of the dataview, I want two entities. The moment I am placing the second entity as row, the sorting of first entity is not working.
Any alternative for that. in the given screenshot, NEt Revenue per partner, net rate per hour……. are the members of first entity on which I want to apply sort function
And KPI and YOY Growth% are the members of second entity in the row.
