By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,208 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,208 IT Pros & Developers. It's quick & easy.

Pivot Chart / Table - Calculated field on the fly

P: 6
Is there any way to show a field in a pivot table/chart that is calculated based on other fields of the pivot?

I have the following table:

Date; DescriptionField_1;[DescriptionField2;DescriptionField_n;] Slots; EmptySlots

I want to know the evolution of empty slots/slots ratio, and graph it on a chart; however, I need to be able to show the correct ratio as I drop and remove the DescriptionFields from the pivot. So I need that ratio field calculated based on the pivot chart's SumOfSlots and SumOfEmptySplots values

Is this possible?

Thanks
Sep 19 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.