Hi,
I am a new user. I have a table Sale, location, EmployeeName, and other column. I added a pivot table, under dimension - add location. Measure I would like to add Q1,Q2,Q3 and Q4. I used the below formula for Q1 Measure
Q1 = Sum(Aggr(If(Sum(NCH) >= Max(TOTAL <SkillGroup_Location> NCH) * 0.75,Sum(NCH)),SkillGroup_Location,AssociateName))
I am error in expression. 😞
Can anyone help me? Please
