Clicking into Data in pivots

Hi all, does Smartsheet have the capability of clicking into data in pivots. For example in the image below if I were like to view the 35 items in column two. In excel I can just click the 35 and then it would populate a sheet with all of them. Does Smartsheet have that capability?


Tags:

Answers

  • Hi @JDSpec13

    While Smartsheet Pivot does not support this functionality out of the box, it is fairly easy to replicate using a report or a series of reports that look at the source data. You will want to look into group/summary functionality in Reports to make it look nice.

    Happy to answer any further questions!

    Matthew Strehler | Senior Solutions Consultant

    New Era Technology

    Matthew.Strehler@NewEraTech.com | neweratech.com