ruthhacche
Board Regular
- Joined
- Sep 22, 2017
- Messages
- 84
I have a dynamic list of my products by profitability that refreshes to the latest profit values.
I have a separate pivot to show product sales analysed by customer - with a slicer by product. Is there any way I can sort that slicer in order of profitability using that dynamic list so that my most profitable products are at the top of the slicer - they are the ones we are most likely to need to analyse by customer?
I have a separate pivot to show product sales analysed by customer - with a slicer by product. Is there any way I can sort that slicer in order of profitability using that dynamic list so that my most profitable products are at the top of the slicer - they are the ones we are most likely to need to analyse by customer?