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 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.