C
cjb2486
I have added a calculated item in my pivot table that calculates the %
of the total spending with certain vendors for each line. This seemed
to be the only way to do it because I have multiple columns
representing multiple years and thus, the calculated item spans
multiple columns. It works great except when it gets to the bottom of
the table, it merely adds up all the percentages above it rather than
continuing the formula onto the total row and giving me the overall
spend with these vendors as a % of the total.
Any thoughts would be appreciated. Thanks.
of the total spending with certain vendors for each line. This seemed
to be the only way to do it because I have multiple columns
representing multiple years and thus, the calculated item spans
multiple columns. It works great except when it gets to the bottom of
the table, it merely adds up all the percentages above it rather than
continuing the formula onto the total row and giving me the overall
spend with these vendors as a % of the total.
Any thoughts would be appreciated. Thanks.