Load order sort with Aggr

[Kushal_Chawda]

Hi All,

I have attached the sample data and the QVW file.

In QVW file there is one straight table created in which there is one expression which calculates the status "New" or "Repeated".

Now, my straight table dimensions are sorted as required from back end itself (check the order by in script).

Straight table works fine as expected. What I want is that, I want to show the count of "Repeated" status in text object.

If you export the straight table in excel, count of the repeated status is 1306, which I want to show in text object.

Note: User can select anything from dimension and count should work dynamically based on selection

I tried the same expression using Aggr, but seems to be wrong. May be it's easy but get stuck.

[sunny_talwar]

Thank you ...lol

[Kushal_Chawda]

ye bhi chal raha

=Sum(Aggr(if(START_DATE_DEFECT1-Below(TOTAL START_DATE_DEFECT1,1,1)>731 or Below(TOTAL Repeated_Defect1,1,1)<>Repeated_Defect1,0,1), GBU_D1, BU_D1, COMPLAINT_NO_D1, Facility_D1, COMPLAINT_DATE_D1, START_DATE_DEFECT1, BU_DEFECT1, DEFECT_LOCATION1, Repeated_Defect1))