Hi all,
Im hoping someone has some insight into what I might be able to do. In the below picture I set up a pivot table that shows what performances constituents have gotten tickets for and attended. However I would like to make it so that each separate performance appears in its own row, along with the date, type, and attended date. Does anyone have any ideas on how to achieve this?
So I would like it so each row contains all the performances split out. If this cant be done in analytics but people know how to do it in excel that would be a helpful alternative. The optimal column set up would be ID > Name > Performance 1 > Date 1 > Type 1 > Attended 1 > so on and so forth for each performance.
Thanks!
Hi Zachary,
Pivots create a hierarchy from the fields on the Rows area. Pivots don't support breaking that hierarchy to "ungroup" constituents and sort by performance. We would need to flip the order of the fields to get the sort to be performance and then constituent. Alternatively, you can download the widget as CSV, which will include the constituent information on every row, and then resort it in Excel.
Or if you are looking for one row per performance with a count of constituents, we'd remove the 2 constituent fields from rows, and then add a value for Constituent ID as a Unique Count.