B
Brady
I want to show the percent of column a row has for the subtotal in my pivot
table. See example below. I have figured out how to do this if I use the
option to have subtotals appear a the bottom and use a function just outside
the pivot table to the right. However, I prefer my subtotals at the top and
there is no text in the top row like in the bottom that says "XXX subtotal".
I started to write a macro that would do this but I can't figure out how to
determine if a row is a subtotal row. Any ideas on how to determine if a
particular row is a subtotal row?
I was hoping that activecell.pivotcell.pivotcelltype would tell me but it
gives me the same value for both a data row and a subtotal row. I even
thought about looking for the format style when I applied a formating style
to the table. IE. if it's bold it's a subtotal field. But that did not
work either.
Any ideas?
Blue 80
item1 50 62.5% 50/80
item2 20 25% 20/80
item3 10 12.5% 10/80
Red
item4
item5
Gren
item6
item7
table. See example below. I have figured out how to do this if I use the
option to have subtotals appear a the bottom and use a function just outside
the pivot table to the right. However, I prefer my subtotals at the top and
there is no text in the top row like in the bottom that says "XXX subtotal".
I started to write a macro that would do this but I can't figure out how to
determine if a row is a subtotal row. Any ideas on how to determine if a
particular row is a subtotal row?
I was hoping that activecell.pivotcell.pivotcelltype would tell me but it
gives me the same value for both a data row and a subtotal row. I even
thought about looking for the format style when I applied a formating style
to the table. IE. if it's bold it's a subtotal field. But that did not
work either.
Any ideas?
Blue 80
item1 50 62.5% 50/80
item2 20 25% 20/80
item3 10 12.5% 10/80
Red
item4
item5
Gren
item6
item7