mardi 24 février 2015

Group data in pivot tables by advanced rules

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


Input data


This is, what I am able to achieve


enter image description here


And this is, what I am trying to achieve


enter image description here


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