Hi,
Could someone help design a macro to design a pivot based on this piece of data:
The two columns that I need in the pivot are company and amount (but need to adjust number format field to $ sign) and introduce a new field that would reflect the ratio each company represents from gross amount. I will post what I'd like the pivot to look like in the next post.
<tbody>
</tbody>
Could someone help design a macro to design a pivot based on this piece of data:
The two columns that I need in the pivot are company and amount (but need to adjust number format field to $ sign) and introduce a new field that would reflect the ratio each company represents from gross amount. I will post what I'd like the pivot to look like in the next post.
Date | ID | REf # | Amount | Company |
2/27/2017 | 111 | 201701 | 100 | IBM |
2/27/2017 | 222 | 201702 | 100 | HP |
2/27/2017 | 333 | 201703 | 500 | IBM |
2/27/2017 | 444 | 201704 | 200 | Ford |
2/27/2017 | 555 | 201705 | 300 | IBM |
2/27/2017 | 666 | 201706 | 600 | IBM |
2/27/2017 | 777 | 201707 | 200 | HP |
<tbody>
</tbody>