pivot table issue

[nishpearl123]

PIVOT TABLE

I have datewise data for debtor realization.

I want to use PIVOT Table & group the data with the interval of 15 days i.e. 1st interval - 0 -15,
2nd interval - 15 -30,
3rd interval - 30-45 etc.

but when i group the data with Pivot table options, it groups as below
1st interval - 0 -15,
2nd interval - 16 -30,
3rd interval - 31-45 etc.

Can you assist?

Regards, ni****h

 

[Misca]

The Pivot Table seems to be doing it right in my opinion. Doing it your way puts the 15's, 30's etc in two groups.

 

[Barbara Excel]

The split in the Pivot Table looks correct to me, my data always looks like that when I use this function. The data groupings never overlap with the same value being in two groups

Hope That Helps
Barbara Excel