Hi all, i have created a pivot to show top 10 clients for every desk by cash. My problem is that's the subtotals are showing the sums of only the top 10 clients for each desk. Instead, I would like them to show the total cash for the entire desk.
Is there a way of making the Excel do this?
Many thanks!
Is there a way of making the Excel do this?
Many thanks!
