Hi All,
I have been trying to come up to speed on Pivot Tables lately. I have alot more recent experience in writing Access reports and I was trying to recreate some of those reports with Pivot Tables.
My question is this, if I have a Pivot Table (PT) and my row fields are City & State, how can I figure a citie's total as a percentage of it's state ? I can put in percentages but they figure each row fields percentage of the Grand Total. Ideally I'd like to see each cities % of ST and each ST's % of the Grand Total.
Is this a "hiccup" of PTs ?? I thought I might have caught a remark about this on the web but this is the first time I've spent the time to post about it...
Thanks very much !!!!
Joe in Oxford, CT
I have been trying to come up to speed on Pivot Tables lately. I have alot more recent experience in writing Access reports and I was trying to recreate some of those reports with Pivot Tables.
My question is this, if I have a Pivot Table (PT) and my row fields are City & State, how can I figure a citie's total as a percentage of it's state ? I can put in percentages but they figure each row fields percentage of the Grand Total. Ideally I'd like to see each cities % of ST and each ST's % of the Grand Total.
Is this a "hiccup" of PTs ?? I thought I might have caught a remark about this on the web but this is the first time I've spent the time to post about it...
Thanks very much !!!!
Joe in Oxford, CT