I have an spreadsheat, let's say A,B,C,D and E with the amount
A,B,C, are unique, but D happens more than once (4 times) for each D the E amount is the same,
I want to sum up all D records, with just 1 E for them (not 4)
i don't want to delete any position from the pivot table data source
anyone has an idea?