This content has been marked as final.
Show 2 replies
-
1. Re: Dynamic Sort With Level of Detail Functions
Simon Padget Jul 8, 2016 8:13 AM (in response to Anna Chan)Hi Anna,
are you able to post a workbook?
Without that it is really hard to tell.
What I would check off the bat, though:
- is this table calc set up correctly for each measure? It may be that it is calculating it at a "cell" level, so everything is getting a 1!
- you are using SUM( [MAX xxxx] ) -this might also be a cause (though feels less likely)
- are your LoD calcs working as you would expect. Always best to chuck all your calcs into a simple table and check that first
hope some of that helps!!
Simon
-
2. Re: Dynamic Sort With Level of Detail Functions
Antigone Oreopoulos Jul 27, 2016 4:22 PM (in response to Anna Chan)Hi Anna.
I just had this same trouble myself.
My measures within the parameters involve level of detail and I suspect this is why the using the default aggregation sort does not work. When I changed the aggregation of the sort (the option is beside the measure you choose to sort on under the sort tab) to either max or min, instead of sum, the sort works properly.
Antigone