I have a very simple list with 2 colums. Colomn A is the product name, Column B is the weight.
Column A is using the unique function to filter my unique produst names.
Column B is using MAXIF function to seach for the MAX weight for that specific product name.
I want to use this sheet as an intermediate sheet for some dashboarding.
The Column A and B work as a Charm. If I fill new lines to my DATA Table, the functions do the job, so all is OK there.
Now for my problem. I have created a PIVOT TABLE on Column A and B. Where I show all the different MAX Weights and the count of the product names.
In that PIVOT TABLE I then clicked right on the Weights and used the group function to group my weights by 5 kgs.
Again, aal works fine there.
But now, if I add data to my DATA Table, and refresh the pivot table, the grouping is gone???
How can I lock this ?
Column A is using the unique function to filter my unique produst names.
Column B is using MAXIF function to seach for the MAX weight for that specific product name.
I want to use this sheet as an intermediate sheet for some dashboarding.
The Column A and B work as a Charm. If I fill new lines to my DATA Table, the functions do the job, so all is OK there.
Now for my problem. I have created a PIVOT TABLE on Column A and B. Where I show all the different MAX Weights and the count of the product names.
In that PIVOT TABLE I then clicked right on the Weights and used the group function to group my weights by 5 kgs.
Again, aal works fine there.
But now, if I add data to my DATA Table, and refresh the pivot table, the grouping is gone???
How can I lock this ?
