Hello,
i have a input file that will update couple of times in every week/month and based on that i have to create pivot table. for example- end of each week input file will update with new data that means this file will have four table of data and will have four pivot table. challenge is how can i make a workflow that will create separate new pivot table every time with new data from same input file.
Input file - (2 weeks of data)
| January 7th | |
| ITEM1 | ITEM2 |
| A | 45345 |
| B | 68017.5 |
| C | 102026.3 |
| D | 153039.4 |
| A | 789879 |
| B | 1184819 |
| C | 1777228 |
| D | 2665842 |
| | |
| | |
| January 15th | |
| | |
| ITEM1 | ITEM3 |
| A | 768 |
| B | 1536 |
| C | 3072 |
| D | 6144 |
| A | 789879 |
| B | 1184819 |
| C | 1777228 |
| D | 2665842 |
expected output- (2 pivot table. first from Jan7th and second from Jan15th)
| | |
| Row Labels | Sum of ITEM2 |
| A | 835224 |
| B | 1252836 |
| C | 1879254 |
| D | 2818881 |
| Grand Total | 6786195 |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| Row Labels | Sum of ITEM3 |
| A | 768 |
| B | 1536 |
| C | 3072 |
| D | 6144 |
| Grand Total | 11520 |
