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.
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.
See attached example.
Retrieving data ...