I was wondering is there any way how to create pivot table in Excel with bit more advanced group by rules? I am trying to create pivot table that will represent number of records for specified data ranges. less than 3 days, 3 - 7 days, more than 7 days
These are imput data
This is, what I am able to achieve
And this is, what I am trying to achieve
Is there any way how to achieve something like this using pivot table? I am able to create something like this using macro, but it is kinda overkill. I assume there is something like this already implemented in Excel
Aucun commentaire:
Enregistrer un commentaire