excel - Add turnover column to my pivot table using PowerPoint -
i using powerpivot create metrics. on 1 pivot table, want show hires, terms , actives , turnover % each month.
i have hires, terms & actives powerpivot data working, not know how can add turnover calculation.
is there way insert new column pivot table , run simple division calculation in it?
*tried posting image of data, not sure why site not post image me
one line of of table such
division | hires | actives | terms | turnover corporate | 5 | 150 | 3 | (terms/actives)
you can following measures:
sumactives:= sum(<fact table>[actives]) sumterms:= sum(<fact table>[terms]) turnover:= [sumactives] / [sumterms]
Comments
Post a Comment