Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am building a PIVOT table. I have been facing issue in getting the Correct AVG(Average) values for the table.
I have attached an Excel to showcase the issue.
Thanks,
H
Hi,
Based on the excel, it looks like you need average days aggregated over cycle and code. If this is the case, this expression may work: aggr(avg(DAYS),Cycle, Code)
If you upload a qvw this would be easier to test.
Hope that helps.
Matt
See attached example.