View with uniq values as fields

I have a table:

  • team(text) - activity(text) - month(YYYY-MM) - allocation(float>0)
  • team(text) + activity(text) + month(YYYY-MM) - is unique

I need view where:

  • I can edit allocation values
  • every unique month seen as filed: team(text) - activity - month1 - month2, - month3…
  • cells are allocations

In excell/spreadsheed Icando it in pivot table.
But it’s not editable view.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.