Cost Per square meter Calculation
I have the following data;
| IssueNo |
Consumeddivision |
Week |
Year |
IssueValue |
Area |
Period |
| 1056492 |
CHEP |
13 |
2013 |
5169 |
149615 |
4 |
| 1056492 |
CHEP |
13 |
2013 |
7236.6 |
149615 |
4 |
| 1056492 |
CHEP |
13 |
2013 |
15507 |
149615 |
4 |
| 1056492 |
CHEP |
13 |
2013 |
24122 |
149615 |
4 |
| 1056493 |
SIMO |
13 |
2013 |
7236.6 |
178349 |
4 |
| 1056499 |
CHEP |
13 |
2013 |
758.12 |
149615 |
4 |
| 1056500 |
CHEP |
13 |
2013 |
87.6 |
149615 |
4 |
| 1056501 |
KAP |
13 |
2013 |
17.52 |
92480 |
4 |
| 1056502 |
SIMO |
13 |
2013 |
26.28 |
178349 |
4 |
| 1055524 |
CHEP |
7 |
2013 |
2146.2 |
149615 |
2 |
| 1055525 |
TOR |
7 |
2013 |
1620.6 |
199100 |
2 |
| 1055525 |
TOR |
7 |
2013 |
3540.1 |
199100 |
2 |
| 1055525 |
TOR |
7 |
2013 |
3854.4 |
199100 |
2 |
| 1055525 |
TOR |
7 |
2013 |
8584.8 |
199100 |
2 |
| 1055526 |
KAP |
7 |
2013 |
1376 |
92480 |
2 |
| 1055526 |
KAP |
7 |
2013 |
7008 |
92480 |
2 |
| 1055526 |
KAP |
7 |
2013 |
3034.37 |
92480 |
2 |
| 1055526 |
KAP |
7 |
2013 |
1620.6 |
92480 |
2 |
| 1055526 |
KAP |
7 |
2013 |
578.16 |
92480 |
2 |
| 1055526 |
KAP |
7 |
2013 |
735.84 |
92480 |
2 |
| 1055530 |
KAP |
7 |
2013 |
5080 |
92480 |
2 |
| 1055530 |
KAP |
7 |
2013 |
1314 |
92480 |
2 |
| 1055531 |
KAPT |
7 |
2013 |
10160 |
90845 |
2 |
| 1055531 |
KAPT |
7 |
2013 |
16640.4 |
90845 |
2 |
| 1055531 |
KAPT |
7 |
2013 |
5256 |
90845 |
2 |
| 1055531 |
KAPT |
7 |
2013 |
4230.8 |
90845 |
2 |
| 1055531 |
KAPT |
7 |
2013 |
15767.25 |
90845 |
2 |
| 1055532 |
KAP |
7 |
2013 |
16640.2 |
92480 |
2 |
| 1055532 |
KAP |
7 |
2013 |
15767 |
92480 |
2 |
| 1055533 |
CHEP |
7 |
2013 |
10158.62 |
149615 |
2 |
| 1055533 |
CHEP |
7 |
2013 |
16640.4 |
149615 |
2 |
| 1055533 |
CHEP |
7 |
2013 |
5256 |
149615 |
2 |
| 1055533 |
CHEP |
7 |
2013 |
15767.23 |
149615 |
2 |
| 1055533 |
CHEP |
7 |
2013 |
24528 |
149615 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055548 |
KAPT |
7 |
2013 |
300 |
90845 |
2 |
| 1055550 |
CHEP |
7 |
2013 |
7560.67 |
149615 |
2 |
| 1055550 |
CHEP |
7 |
2013 |
1620.6 |
149615 |
2 |
| 1055550 |
CHEP |
7 |
2013 |
3942 |
149615 |
2 |
| 1055550 |
CHEP |
7 |
2013 |
2430.9 |
149615 |
2 |
| 1055550 |
CHEP |
7 |
2013 |
4300 |
149615 |
2 |
| 1055551 |
KAP |
7 |
2013 |
1376 |
92480 |
2 |
I need to achieve the following;
Calculate the cost per square meter which is basically - The sum cost of Issuevalue/Distinct SUM OF Area, The Area varies for the different consumeddivision and based on the selections on the consumeddivision in the filter, We should have the sum of the Area of the selections e.g
If we Select Chep and Kap in consumeddivision filters we should have the sum of issuevalue for the two locations/Sum area of (Chep and Kap)
Thanks and looking forward to your assistance
Regards