I'm importing this csv:
Person_Number | Company | FTE | Salary |
|---|
001 | A | 0.5 | 40000 |
001 | B | 1 | 50000 |
002 | A | 1 | 30000 |
Is there a way to pre process data in order to group by Person_Number using SUM/AVG/MAX (or complex formulas) in other fields?
The purpose is to make charts that are not only Pivot Tables but also Bar Charts and so on
