I have a question about sorting in pivot tables. The pivot table shows the
<tbody>
</tbody>
in the left columns is the Customer Code and Customer Name
The table is sorted by ITEM_TOTAL_SALES with all SALES_REPS ( the filter in the left corner ).
When I set the filter just to Bob (in this example) then it is no longer sorted and mixed up.
Is there a way (settings?) to make sure that ITEM_TOTAL_SALES is still sorted also after changing the sales rep in the filter?
THANK YOU ALL
Sum of ITEM_TOTAL_SALE | Sum of TOTAL DISCOUNT AMOUNT | Sum of Gross Margin |
<tbody>
</tbody>
in the left columns is the Customer Code and Customer Name
The table is sorted by ITEM_TOTAL_SALES with all SALES_REPS ( the filter in the left corner ).
When I set the filter just to Bob (in this example) then it is no longer sorted and mixed up.
Is there a way (settings?) to make sure that ITEM_TOTAL_SALES is still sorted also after changing the sales rep in the filter?
THANK YOU ALL
Last edited: