Hi all,
i have 1 year sales data which exceeds 5 million rows, my issues are as follows
- each row is in a different currency which i need to convert them all based on monthly rate (i have a monthly rate sheet)
- i need to combine them all and use 1 pivot table
- the data is heavy please help
- i need a column for total tax which is : the sum of (Ads Taxa1, Ads Taxa2, Ads Taxa3) without the alphabetical codes and i use "Ads Totl" currency code (which is the first 3 letters of the "Ads Totl" cell)
- "Ads Fare" cell have their own currency which i separate by taking the first three letter of the cell, "Ads Totl" cell i do the same.
"below is few rows example of the data that i have"
please help me urgently
<colgroup><col span="2"><col><col><col span="3"><col><col span="3"><col><col></colgroup><tbody>
</tbody>
i have 1 year sales data which exceeds 5 million rows, my issues are as follows
- each row is in a different currency which i need to convert them all based on monthly rate (i have a monthly rate sheet)
- i need to combine them all and use 1 pivot table
- the data is heavy please help
- i need a column for total tax which is : the sum of (Ads Taxa1, Ads Taxa2, Ads Taxa3) without the alphabetical codes and i use "Ads Totl" currency code (which is the first 3 letters of the "Ads Totl" cell)
- "Ads Fare" cell have their own currency which i separate by taking the first three letter of the cell, "Ads Totl" cell i do the same.
"below is few rows example of the data that i have"
please help me urgently
Bas Pnrr Pnr | Bas Agtn No | Ticket_Number | Ads Fare | Ads Taxa 1 | Ads Taxa 2 | Ads Taxa 3 | Ads Totl | Itn Clsc 1 | Itn Clsc 2 | Bas Dais Dt | Ads Tour | Ads Orin |
EVLRQO | 8621040 | 9181414188 | BHD 38.000 | 5ZR | 50BH | 10HM | AED 445 | N | 05-Oct-16 | |||
FEIPDJ | 8620997 | 9181407103 | BHD 38.000 | 5ZR | 50BH | 10HM | AED 445 | N | 05-Oct-16 | |||
JHZRWV | 8621040 | 9181414191 | BHD 38.000 | 5ZR | 50BH | 10HM | AED 445 | N | 05-Oct-16 | |||
XTJDNB | 8649029 | 2428450116 | AED 500 | 40DV | 100YQ | 180XT | AED 820 | N | N | 05-Oct-16 | ||
XTJDNB | 8649029 | 2428450117 | AED 500 | 40DV | 100YQ | 180XT | AED 820 | N | N | 05-Oct-16 | ||
JTBJNO | 8649029 | 2428450108 | AED 510 | 40DV | 400YQ | 280XT | AED 1230 | W | W | 05-Oct-16 | IT0116DXBCPCGF1 |
<colgroup><col span="2"><col><col><col span="3"><col><col span="3"><col><col></colgroup><tbody>
</tbody>