# Use the calculated values in pivot table

• Hello,

Is it possible to create a pivot chart to get the grand total subtract from 100% (eg 660), and also place a target line (eg 89% of 660 = 587), and a 100% line on the graph.
The result at the moment is the sum of a number of minutes per day. (eg 25) (This is calculated by the pivot table)
So I would like that I see 635 in stead of 25, and if it is possible that this number is converted to 96% from 660 in the displays.
The problem, for me, is that 25 is a calculated number and not directly from the data retrieved. How can I use the calculated data, and use the result.
Attached the file with the PivotChart and data.
Thanks for helping,

## Files

• Re: Use the calculated values in pivot table

Thank You, That is beautiful, but now I try to understand what you did.

And I do not understand it.

I think _Field1 is the key but how it works = ?? (for me)
Can I get a little explanation please. I use Office 2007

aisietie

• Re: Use the calculated values in pivot table

• Re: Use the calculated values in pivot table

Thanks again, thats explains a lot. But I still have 1 problem, the values in the chart are Summed in the chart, and not summed in the table.
See the .jpg

aisietie

## Images

• Re: Use the calculated values in pivot table

Un-stack.

• Re: Use the calculated values in pivot table

Thank You verry much.

aisietie

• Re: Use the calculated values in pivot table

Hi,

If possible, just one more thing.
Is it possible to put a horizontal maximum line and a Target line on the chart?
Do I need to add a new column in the table? Where do I need to put the values?

aisietie

• Re: Use the calculated values in pivot table

It is OK, I inserted 2 calculated Items (= 660 & = 587) in the pivottable, and the 2 horizontal lines Max en Target, are added in the chart.

aisietie

• Re: Use the calculated values in pivot table

Herbds7,

Can you explain where the Months field is stuated in the table?
I see it in the Fields, but not in the data table.

How is this field created?

aisietie

• Re: Use the calculated values in pivot table

"Months" field was created by Group option.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!