Forum Discussion
Solved
filtre data
is there a simple solution (filter for example) to go from table 1 to 2. eliminate repetitive codes and calculate the quantity at the same time?
safwen That would be with a pivot table.
safwen Pivot table is best for this case that already shown by Riny_van_Eekelen. If you prefer formula solution then can go with- (see the attached file).
=UNIQUE(CHOOSE({1,2,3},A2:A12,B2:B12,SUMIFS(C2:C12,A2:A12,A2:A12,B2:B12,B2:B12)))safwen That would be with a pivot table.
Riny_van_Eekelen Hi Sir i tried the same function but i didn't get the same result. can you please help me with steps ?
safwen You just need to change the layout of the pivot table a bit. On the Design (Creacion) tab, you'll find some layout buttons on the far left. The first two allow you to get rid of the sub- and grand totals.
Then, in the Report Layout section, choose Show in Tabular Form first and then Repeat All Item Labels.
