I have a pivot table with the amount of worked days for each employee,calculated as expressions from the employees' activities, per year. I need to calculate an average an worked days per year and use the said average on some other pivot tables. So as a solution I was thinking about making the said average a variable that I can call in other pivot tables.
Now the question is:
Is there a way in which I can reference an expression in a pivot table, when calculating a variable? If not, is there any other solution to my problem?