Grouping row values in pivot table

In Excel, you can group values together in pivot table rows. For example, creating day ranges of 1-7, 8-14. I want to summarize totals by day ranges.

Is that possible in Quicksight?

@dturner sounds like you need to add a calculated field to group the values how you want. Something like:
ifelse({day}>=1 AND {day}<=7, ‘01-07’, {day}>=8 AND {day}<=14, ‘08-14’, …)

Then add that field to your pivot table.

The reason I add the leading 0 is to make sure it sorts correctly (since its a string, so default will be sorting alphabetically).

Sounds good. I’ll definitely try this.

Thanks.