Forum Discussion

ahussnain's avatar
ahussnain
Icon for Advocate IV rankAdvocate IV
8 years ago

The Aggregate for Year includes the values excluded for Quarters

Hi, Please read through with patience as explanation of the problem may not be great.   I have table Site and Sales.    Site is Name and Quarter Acquired SiteX Q1,2017 SiteY Q2, 2017 SiteZ Q2,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI ahussnain,

 

Can you please provide something detail? I can't find the corrsponed records from your expected result and original table.

 

Bold part:

Q1       Q2              Q3                      2017 (yearly aggregate)
10    (11+21)    (12+22+32)       (10+20+30+11+21+31+12+22+32)

 

Regards,

Xiaoxin Sheng