Ask Your Question

Pivot table grouping by day(s) of week

asked 2017-03-02 00:54:28 +0200

Herolds Salads Inc gravatar image

Would like to see the option of grouping data by days of the week. (Sun, Mon etc...)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-02 01:45:13 +0200

m.a.riosv gravatar image

updated 2017-03-03 00:45:16 +0200

I think there is not one. Except you can and add a column to your data with the day of the week.

image description

edit flag offensive delete link more


Yes, use Helpercolumn with =TEXT(A2:"NN")

karolus gravatar imagekarolus ( 2017-03-02 02:04:31 +0200 )edit

Yeah I already know about the the adding extra column. The adding an extra column is a kind of clunky way of doing this. Much neater and cleaner way is an added option to group in this manner.

Herolds Salads Inc gravatar imageHerolds Salads Inc ( 2017-03-02 20:04:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-02 00:54:28 +0200

Seen: 329 times

Last updated: Mar 03 '17