Group by week

[Caribeiro77]

Hy,

I have a pivot table off sales analysis, is it possible to group sales by week, i already grouped by month, but i don't know if it's possible to group by week....

Thanks

 

[crook_101]

Hi,

It is possible if you have weeks in your original data....if it is only "months" you would not be able to determine when the actual sales happened. If you have the individual dates, you could add an additional column in your originl data to show "weeks" and include this field in your PT

Regards,
Ian