Pivot tables grouping

William Briggs · 05/11/21

In excel you can group pivot table rows by days under the "PivotTable Analyze" tab. Does Smartsheet have the same functionality?

Genevieve P. · 05/14/21

Hi @William Briggs

I have to admit I'm not that familiar with Excel's "PivotTable Analyze" tab. Would you be able to post a screen capture of your current sheet in Smartsheet and identify what you're looking to do? (But please block out any sensitive data).

If you're looking to Group rows, you may want to look into using a Report to Group based on a certain criteria. For example, you could have a column set up which finds the weekday of your date column (using the WEEKDAY Function), then you can use this as your Group in the Report, and use the Summary function to calculate data. See: Configure Grouping to Organize Results in Report Builder

Would that work for you?

Cheers,

Genevieve

William Briggs · 05/14/21

Thank you Genevieve. I will post a picture of ungrouped the grouped. I set it to group by days starting at a certain date and by 7 days.

Genevieve P. · 05/17/21

Hi @William Briggs

Smartsheet has different functionality, so there isn't a setting like this within a sheet to automatically create this view. The closest thing would be to create a Report, as I mentioned previously.

You would want to have a column in your sheet that identifies the Weeknumber for each date.

Screen Shot 2021-05-17 at 4.20.46 PM.png

This would then allow you to Group a Report by this Week number, and then Summarize by week number like so:

(Note: I've filtered my Report by the Date column being in the last 30 days, but you can adjust this to be different criteria).

Screen Shot 2021-05-17 at 4.22.49 PM.png

You can collapse the header rows so that you only see the grouped information:

Screen Shot 2021-05-17 at 4.24.56 PM.png

If it was important for you to see both dates (start and end date for the week), then you could add a second, hidden, helper-column in your source sheet to replicate the same date from the Date column. Then you can use this in your Report and Summarize based on the Latest date. In Smartsheet the totals are displayed on the top row.

Screen Shot 2021-05-17 at 4.26.55 PM.png

This webinar has more information: Redesigned Reports with Grouping and Summary Functions

Let me know if I've misunderstood what you're looking to do!

Cheers,

Genevieve

Pivot tables grouping

Answers

Categories