How can we group dates in Pivot Table?

[dvm49]

Hello Friends,

I am trying to calculate cumulative data usage for each day and made a pivot but unable to figure out on how to get sum of usage for each day? Can someone take a look at the attached excel sheet and suggest?

Thanks

 

[GraH - Guido]

Hi @dvm49 ,

Your date time is stored as text and thus day grouping in the pivot does not happen. Either convert is with text to column feature, or add a column to force it to a decimal value which you can format as date. Or use a copy past special, divide by 1.

I had to do some mojo on the total "MB" column because I am on EU settings, but yours works fine on your end.

 

[vletm]

Modify all texts to numbers
Create a Pivot table