Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You couldn't put the multiple results of a pivot within a variable and also you couldn't refer from one object to another. You will always need to calculate your needed results within one object.
In your case you might be getting your results with nested aggregations with the aggr-function, maybe something like this:
avg(aggr(count(WorkingDays), Employee, Year))
To get an explanation what is meant, see: AGGR...
- Marcus
Could be
Aggr(Avg(TOTAL <day> [Worked Days Expression], year))
Could be
Aggr(Avg(TOTAL <day> [Worked Days Expression], year))
You couldn't put the multiple results of a pivot within a variable and also you couldn't refer from one object to another. You will always need to calculate your needed results within one object.
In your case you might be getting your results with nested aggregations with the aggr-function, maybe something like this:
avg(aggr(count(WorkingDays), Employee, Year))
To get an explanation what is meant, see: AGGR...
- Marcus