2 Replies Latest reply on Nov 20, 2016 6:02 PM by Trần Ngọc Sơn

    Cannot blend the secondary data source because one or more fields use an unsupported aggregation.

    Trần Ngọc Sơn

      Hi all,

      I use Data Blending data source. And I have a problem with calculation in Crosstab with Error when i drap drop LQC (copy) (copy) to sheet 3.

      I atach a file workbook.

      In this case, I want to calcutation Grand total LQC = Grand total D_LQC (by Sum) / Grand total  Q'tyVC (by Average)

      I try Sum(D_LQC)/AVG (Q'tyVC) but it doesn't right.

      Can you help me fix error?