I have a data set in pivot table which has 12 months and each month has two
items Capital & Operating spend. I want to get percent % of total for each
item but not percent of whole year. I want each month to be the base, for
instance if I spent 12 hundered per year and 100 each month, in January i
spent 37 capital and 63 operating. % of total function should return 37% Vs
63% and not 3.08% and 5.25% which are based on total year. Thanks in advance
for your help!