Hi Everyone:
I have been trying to search this issue for a while with no luck:
I have a list of people with certain classifications and need to "roll-up" some of those classifications into high level groups. For instance, if I have a list of people with their favorite ice cream and the $ they have spent on ice cream. Some like vanilla, some like chocolate, and some like vanilla and chocolate equally.
I want to create a pivot table that shows the people as row items and the amount of $ they have spent on vanilla (one column) and chocolate (second column) ice cream.
So, this is simple for people who like vanilla or chocolate, but not both. My question is: how can I add the total amount of money for vanilla+chocolate people into BOTH the vanilla and chocolate column (i know this wouldn't make sense to add total value to both, but that is what I am trying to do).
I also want the table to remain interactive, so that when I click on the values, it expands into another sheet that shows the details for each person (e.g., how many purchases they made, etc.)
Thank you for your help -- please let me know if this is not descriptive enough.
P.S. - I don't know how to do macros =(
I have been trying to search this issue for a while with no luck:
I have a list of people with certain classifications and need to "roll-up" some of those classifications into high level groups. For instance, if I have a list of people with their favorite ice cream and the $ they have spent on ice cream. Some like vanilla, some like chocolate, and some like vanilla and chocolate equally.
I want to create a pivot table that shows the people as row items and the amount of $ they have spent on vanilla (one column) and chocolate (second column) ice cream.
So, this is simple for people who like vanilla or chocolate, but not both. My question is: how can I add the total amount of money for vanilla+chocolate people into BOTH the vanilla and chocolate column (i know this wouldn't make sense to add total value to both, but that is what I am trying to do).
I also want the table to remain interactive, so that when I click on the values, it expands into another sheet that shows the details for each person (e.g., how many purchases they made, etc.)
Thank you for your help -- please let me know if this is not descriptive enough.
P.S. - I don't know how to do macros =(