Please could you provide information of what your expected solution should look like or share a sample workbook.
This seems like a problem that should be solvable a little more information would assist me helping you with a solution.
Hi Emily to me this looks like you want to sort Dept by Field(FY AVG PEP Approved... Descending
have you tried right clicking on the Dept field and using the sort option to apply this. or is there something more on top of what I described that you are trying to achieve
No I want to sort by the field "AGG(FY Avg Volume (PE.." (the last measurement in the column) descending.
By right clicking Dept, there's no option for me to select "AGG(FY Avg Volume (PE.." coz it is from another datasource.
Cheers Emily I understand the issue now.
If you can create a duplicate of the workbook.
If you then apply datasource filters to bring in the top 1000 rows or whatever you feel is sufficient to troubleshoot the issue.
This will reduce the filesize which can be packaged and uploaded.
I can have a look at this and try figure out a solution for you.
1 of 1 people found this helpful
Try using a RANK([Your Field Here],desc)
Then place this on the details shelf. Right click it and go to edit table calculation. Choose the advanced option.
On the left hand side -partition- choose Dept.
On the right hand side -addressing- put FY
Now right click this field thats on the details shelf and change it to discrete.
Place this discrete table calculation between Dept and FY on your rows shelf.
Right click the field on the rows shelf and uncheck the option 'show header'.
What this does is sort based on the rank of that last column but with regards to the department the FY is in.
Thanks Carl! I tried but it doesn't work
I'm travelling overseas soon, I'll work out a sample source file and consult you at a later date. Thanks again!
I'm travelling overseas soon, I'll work out a sample file later. Thanks again!