Jase Alexander
asked on
Excel Pivot Table - updating pivot table after counting unique values
Hi Experts
I hope you can shed some light on something I cant seem to grasp when creating / updating a pivot table
I have created a pivot table from some courtier data we have which basically highlights the number of shipments per state in the US. Our courier, however, lists a tracking number per carton on the shipment so if there are more than on carton making up a shipment, the tracking number is duplicated
I have managed to count the unique values by selecting the necessary options and filter however when I try to refresh the table after this, it remains the same ?
Do I have to remove the table Ive created and recreate the new on with the new settings or is there a way of updating the existing table with the new criteria?
Any suggestions would be welcome
J
I hope you can shed some light on something I cant seem to grasp when creating / updating a pivot table
I have created a pivot table from some courtier data we have which basically highlights the number of shipments per state in the US. Our courier, however, lists a tracking number per carton on the shipment so if there are more than on carton making up a shipment, the tracking number is duplicated
I have managed to count the unique values by selecting the necessary options and filter however when I try to refresh the table after this, it remains the same ?
Do I have to remove the table Ive created and recreate the new on with the new settings or is there a way of updating the existing table with the new criteria?
Any suggestions would be welcome
J
Can you upload the file with explanations of what you are expecting to happen?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.