Dear All,
Thanks in advance for your time to help me with my inquiry.
I have some expenses data where I want to select common or close text from a list and sum the amount spent for a specific month "Mar". Then I will work on creating a dashboard out of it.
Example of output required.
ENOC SITES : 140 ARE. [ Data below is having different Site numbers, but I want to group them all together]
SHARJAH CO-OP : 260 ARE.
<tbody>
</tbody>
Thanks in advance for your support and efforts.
Thanks in advance for your time to help me with my inquiry.
I have some expenses data where I want to select common or close text from a list and sum the amount spent for a specific month "Mar". Then I will work on creating a dashboard out of it.
Example of output required.
ENOC SITES : 140 ARE. [ Data below is having different Site numbers, but I want to group them all together]
SHARJAH CO-OP : 260 ARE.
9-Mar-17 | ENOC SITE 1032 DUBAI UAE | ARE | 95.01 |
8-Mar-17 | SHARJAH CO-OP, HALWAN SHJ ARE | ARE | 16.95 |
6-Mar-17 | AL ZAJIL FAIRS MANAGEM SHARJAH ARE | ARE | 100.00 |
6-Mar-17 | AL ZAJIL FAIRS MANAGEM SHARJAH ARE | ARE | 90.00 |
6-Mar-17 | ADNOC AL ASRAR ABU DHABI ARE | ARE | 114.00 |
6-Mar-17 | SHARJAH CO-OP, HALWAN SHJ ARE | ARE | 73.55 |
6-Mar-17 | AL SHAAB VILLAGE-AL ZA SHARJAH UAE | ARE | 50.00 |
6-Mar-17 | AL SHAAB VILLAGE-AL ZA SHARJAH UAE | ARE | 40.00 |
6-Mar-17 | AL SHAAB VILLAGE-AL ZA SHARJAH UAE | ARE | 100.00 |
6-Mar-17 | AL SHAAB VILLAGE-AL ZA SHARJAH UAE | ARE | 55.00 |
5-Mar-17 | AL MANAMA H/MARKET-BR DUBAI ARE | ARE | 63.90 |
4-Mar-17 | ENOC SITE 1036 DUBAI UAE | ARE | 112.01 |
3-Mar-17 | SHARJAH CO-OP, HALWAN SHJ ARE | ARE | 100.80 |
2-Mar-17 | GIFTS MARKETS GEN.TRAD SHARJAH ARE | ARE | 49.50 |
1-Mar-17 | SHARJAH CO-OP, HALWAN SHJ ARE | ARE | 142.40 |
<tbody>
</tbody>
Thanks in advance for your support and efforts.