ruthhacche
Board Regular
- Joined
- Sep 22, 2017
- Messages
- 84
Is there any way you can change the way sort works at different levels.
I have a visual that I am sorting by descending SF profit per unit. So I can rank how much profit I am making off each account for this product. But within each customer I can drill down to the month. My months are sorted by a month number column (added in pink to demonstrate) but, of course they are not sorting by that month number - they are still sorting by the descending profit per unit. Is there anyway I can make the sorting of the month override the sorting that is applied to the visual. So I want the main lines (with the profit shaded green ) to appear sorted as below but once I drill down into the -£1.2809 I want them to sort using the month numbers (pink) not the descending SF profit per unit.
I doubt it but maybe someone knows a trick?
I have a visual that I am sorting by descending SF profit per unit. So I can rank how much profit I am making off each account for this product. But within each customer I can drill down to the month. My months are sorted by a month number column (added in pink to demonstrate) but, of course they are not sorting by that month number - they are still sorting by the descending profit per unit. Is there anyway I can make the sorting of the month override the sorting that is applied to the visual. So I want the main lines (with the profit shaded green ) to appear sorted as below but once I drill down into the -£1.2809 I want them to sort using the month numbers (pink) not the descending SF profit per unit.
I doubt it but maybe someone knows a trick?
