This content has been marked as final. Show 4 replies
I'm facing the follwing problem.
I've a pivot table with two dimensions:
WorkType, [Division-> Depart-Employee]
Worktype as column
Group [Division-> Depart-Employee] as lines
The metric is hours of work.
I need to create an expression that sums some types of worktype and that its results appear in all columns.
I built the following expression, but the value (although well calculated) only appears for the first condition worktype instead of repeating in all columns.
sum ( aggr( sum(if(WorkType='B' or WorkType='C' or WorkType='D', Hours)),[Division->Depart->Employee]))
How can I solve this requirement ?
Thanks in advance