I am a real novice when it comes to Pivot Tables so am hoping someone can guide me on two issues related to the following pivot table image - https://imgur.com/a/LkX7GTM
1) Notice the columns entitled "Sum of My $s" and "Sum of Count". I want to see this data but not as columns since it makes the table too wide. Rather, I want them as collapsable rows. See the following for a mockup of the desired layout - https://imgur.com/a/GTaCZUo
I have tried by adding the My $s field and Count field to the Rows section of the Pivot Table, but it doesn't end up showing the totals as it does when adding to the Values section. Thus, I get stuck.
2) Is it possible to add a third sub row (collapsable) wherein it is a calculated field - (Sum of My $s)/(Sum of Amount) as well as a fourth sub row calculated as (Sum of Amount/Sum of Count)?
Thank you in advance for any giudance you can provide me with.
1) Notice the columns entitled "Sum of My $s" and "Sum of Count". I want to see this data but not as columns since it makes the table too wide. Rather, I want them as collapsable rows. See the following for a mockup of the desired layout - https://imgur.com/a/GTaCZUo
I have tried by adding the My $s field and Count field to the Rows section of the Pivot Table, but it doesn't end up showing the totals as it does when adding to the Values section. Thus, I get stuck.
2) Is it possible to add a third sub row (collapsable) wherein it is a calculated field - (Sum of My $s)/(Sum of Amount) as well as a fourth sub row calculated as (Sum of Amount/Sum of Count)?
Thank you in advance for any giudance you can provide me with.
Last edited:
