My user wants me to create a report that lists various income statement averages for a given shop
They also want to add a colum in the report that lists the average of the income statement averages for all shops that are in the same sales quintile.
I'm thinking I need a way to indicate which sales (4499_TotalRev) quintile each of the shops is in so I can retrieve the shops in the correct quintile. (Perhaps add a field called quintile and somehow update it)
here is a small sample of the data in the table named incomeStatement
9901_Shop 4499_TotalRev 4999_TotalGrossMargin 5200_GrossMarginNetPayroll
4166 362872 34 22
1110 898000 12 33
1115 645673 56 44
1117 1050815 12 10
1127 591677 88 15
I'm thinking I have to determine what the quintiles are and then find a way to indicate which shop is in which quintile but not sure the best way to do this.
Any help would be greatly appreciated