Data looks like this:
I need to prepare summaries like this:
What I currently do is first prepare a pivot table showing a level higher (Customer level) and then add a helper column flagging customers as either Growning or Degrowning. I do this for Families as well (so that they can be flagged as either Growing or Degrowing) and then take a pivot to get the summary I like.
I don't mind doing this without pivot tables if it's better. I just want to avoid making intermediate summaries at a Customer / Family level (Data is at an account level).
I need to prepare summaries like this:
What I currently do is first prepare a pivot table showing a level higher (Customer level) and then add a helper column flagging customers as either Growning or Degrowning. I do this for Families as well (so that they can be flagged as either Growing or Degrowing) and then take a pivot to get the summary I like.
I don't mind doing this without pivot tables if it's better. I just want to avoid making intermediate summaries at a Customer / Family level (Data is at an account level).