target pivot percentage

[mlaxx]

hy. i have this situation.
I CDEBIT sheet i have a pivot table.
What I want to get. for example for 03.06.2019, for LAMINAT I know that I have target 150. How can I display in the pivot tables for each shift (I, II) how much the percentage has been achieved from the target?

[jomaor1]

Hi,

Select your pivot table, click on "Analyse" Tab> "Fields, Items & Sets"> "Calculate Field"

Give a name to your calculation, and on the Formula write this:"= MP / 150" without the ""

Now on your Values on thepivotTable Fields, click the new added Calculation, and click on "value field settings"> Number Format, and select Percentage.

Done! if you want to, you can also click on "Design" Tab> "Grand Totals" and disable all the totals, so your table can be a little more easier to understand

[mlaxx]

thx. but i have excel2013 whic dont have powerpivot so i dont have the posibilities to use calculate field

[jomaor1]

Really? wow, didn't know you had to have powerpivot for this. But if so, the only way I can think is by adding another column with this calculation on your base table
sorry :/

[CK76]

excel2013 whic dont have powerpivot so i dont have the posibilities to use calculate field

This is not correct. Calculated field has been available since Excel 2007.

Calculated field is only available to Excel Table/Range based Pivot Tables.
It isn't available to Data Model based Pivot Tables (including PowerPivot).

PowerPivot uses DAX measures/calculated columns instead of Calculated fields.