LostInTheTrees
New Member
- Joined
- Jul 23, 2014
- Messages
- 5
Hello!
I've just truly begun exploring the power of Excel Pivot Tables, and I have run into a dilemma that I cannot seem to find an answer to. As a result, I'd love a little insight from those of you with a greater understanding.
I have 2 pivot tables built off the same data. In order to clarify appropriately, the two variables shall be ice cream and customer name. The first pivot table shows Ice Cream flavor, with Customer Name tucked underneath the flavor heading. The second pivot table shows Customer Name, with Flavors tucked underneat each customer name heading.
The values for both are number of purchases and a second number of purchases column converted to rank. Ultimately, I'd love to show the Flavors with Customer name underneath table, its two columns tied to purchase and number of purchase rank, as well as a column showing the relative rank for the customers.
I recognize this sounds like a garbled mess, and I gladly welcome questions for clarification; the system will not currently allow me to attach my dummy document, so I attached a paint image that might (?) add some clarity.
Sincerely,
LostInTheTrees
I've just truly begun exploring the power of Excel Pivot Tables, and I have run into a dilemma that I cannot seem to find an answer to. As a result, I'd love a little insight from those of you with a greater understanding.
I have 2 pivot tables built off the same data. In order to clarify appropriately, the two variables shall be ice cream and customer name. The first pivot table shows Ice Cream flavor, with Customer Name tucked underneath the flavor heading. The second pivot table shows Customer Name, with Flavors tucked underneat each customer name heading.
The values for both are number of purchases and a second number of purchases column converted to rank. Ultimately, I'd love to show the Flavors with Customer name underneath table, its two columns tied to purchase and number of purchase rank, as well as a column showing the relative rank for the customers.
I recognize this sounds like a garbled mess, and I gladly welcome questions for clarification; the system will not currently allow me to attach my dummy document, so I attached a paint image that might (?) add some clarity.

LostInTheTrees