Spreadsheet: 881240d1729213402-converting-data-to-table-to-generate-pivot-table-convert-data-to-table
Sheet: Sheet1

PIC | Department | Revenue | 2024-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total
A | M | Advertisment | 2363 | 2122 | 1174 | 4741 | 4628 | 4629 | 2970 | 2462 | 4514 | 2675 | 3639 | 4611 |  |  | A | Adding a Total column in source data
A | UC | Workshop | 1694 | 2705 | 3874 | 4144 | 2143 | 4197 | 3598 | 2995 | 4560 | 2308 | 1916 | 2974 |  |  |  | Sum of Total | Revenue
B | NC | Advertisment | 3224 | 2536 | 2659 | 2668 | 1863 | 3637 | 2223 | 1975 | 2952 | 4144 | 3953 | 4424 |  |  |  | Department | Advertisment | Interest | TV Comm | Workshop | Grand Total
B | NC | TV Comm | 4710 | 2239 | 3572 | 2318 | 3004 | 1083 | 2696 | 2204 | 4838 | 2165 | 4099 | 1775 |  |  |  | BD | 15761 | 25498 |  | 37726 | 78985
C | BD | Workshop | 4914 | 4800 | 3468 | 4594 | 3125 | 1005 | 3650 | 3942 | 2872 | 2459 | 1412 | 1485 |  |  |  | M | 40528 |  |  |  | 40528
C | BD | Interest | 2781 | 2901 | 3915 | 4904 | 2884 | 1768 | 2080 | 2696 | 1569 |  |  |  |  |  |  | NC | 36258 |  | 34703 |  | 70961
C | BD | Advertisment |  |  |  |  |  |  |  | 2736 | 3893 | 3046 | 1711 | 4375 |  |  |  | UC |  |  |  | 37108 | 37108
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 92547 | 25498 | 34703 | 74834 | 227582
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Adding a Calculated Field in PivotTable
 | is there a way to convert the above yellow to below? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum of Total | Revenue
 | Wish to make dynamtic if possible (meaning any changes to within the yellow will update the table below) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department | Advertisment | Interest | TV Comm | Workshop | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BD | 15761 | 25498 | 0 | 37726 | 78985
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 40528 | 0 | 0 | 0 | 40528
PIC | Department | Revenue | Period | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  | NC | 36258 | 0 | 34703 | 0 | 70961
A | M | Advertisment | 2024-01-31 00:00:00 | 2363 |  |  |  | Sum of Amount | Column Labels |  |  |  |  |  |  |  |  | UC | 0 | 0 | 0 | 37108 | 37108
A | M | Advertisment | 2024-02-29 00:00:00 | 2122 |  |  |  | Row Labels | Advertisment | Interest | TV Comm | Workshop | Grand Total |  |  |  |  | Grand Total | 92547 | 25498 | 34703 | 74834 | 227582
A | M | Advertisment | 2024-03-31 00:00:00 | 1174 |  |  |  | BD | 15761 | 25498 |  | 37726 | 78985
A | M | Advertisment | 2024-04-30 00:00:00 | 4741 |  |  |  | M | 40528 |  |  |  | 40528
A | M | Advertisment | 2024-05-31 00:00:00 | 4628 |  |  |  | NC | 36258 |  | 34703 |  | 70961
A | M | Advertisment | 2024-06-30 00:00:00 | 4629 |  |  |  | UC |  |  |  | 37108 | 37108
A | M | Advertisment | 2024-07-31 00:00:00 | 2970 |  |  |  | Grand Total | 92547 | 25498 | 34703 | 74834 | 227582
A | M | Advertisment | 2024-08-31 00:00:00 | 2462
A | M | Advertisment | 2024-09-30 00:00:00 | 4514
A | M | Advertisment | 2024-10-31 00:00:00 | 2675
A | M | Advertisment | 2024-11-30 00:00:00 | 3639
A | M | Advertisment | 2024-12-31 00:00:00 | 4611
A | UC | Workshop | 2024-01-31 00:00:00 | 1694
A | UC | Workshop | 2024-02-29 00:00:00 | 2705
A | UC | Workshop | 2024-03-31 00:00:00 | 3874
A | UC | Workshop | 2024-04-30 00:00:00 | 4144
A | UC | Workshop | 2024-05-31 00:00:00 | 2143
A | UC | Workshop | 2024-06-30 00:00:00 | 4197
A | UC | Workshop | 2024-07-31 00:00:00 | 3598
A | UC | Workshop | 2024-08-31 00:00:00 | 2995
A | UC | Workshop | 2024-09-30 00:00:00 | 4560
A | UC | Workshop | 2024-10-31 00:00:00 | 2308
A | UC | Workshop | 2024-11-30 00:00:00 | 1916
A | UC | Workshop | 2024-12-31 00:00:00 | 2974
B | NC | Advertisment | 2024-01-31 00:00:00 | 3224
B | NC | Advertisment | 2024-02-29 00:00:00 | 2536
B | NC | Advertisment | 2024-03-31 00:00:00 | 2659
B | NC | Advertisment | 2024-04-30 00:00:00 | 2668
B | NC | Advertisment | 2024-05-31 00:00:00 | 1863
B | NC | Advertisment | 2024-06-30 00:00:00 | 3637
B | NC | Advertisment | 2024-07-31 00:00:00 | 2223
B | NC | Advertisment | 2024-08-31 00:00:00 | 1975
B | NC | Advertisment | 2024-09-30 00:00:00 | 2952
B | NC | Advertisment | 2024-10-31 00:00:00 | 4144
B | NC | Advertisment | 2024-11-30 00:00:00 | 3953
B | NC | Advertisment | 2024-12-31 00:00:00 | 4424
B | NC | TV Comm | 2024-01-31 00:00:00 | 4710
B | NC | TV Comm | 2024-02-29 00:00:00 | 2239
B | NC | TV Comm | 2024-03-31 00:00:00 | 3572
B | NC | TV Comm | 2024-04-30 00:00:00 | 2318
B | NC | TV Comm | 2024-05-31 00:00:00 | 3004
B | NC | TV Comm | 2024-06-30 00:00:00 | 1083
B | NC | TV Comm | 2024-07-31 00:00:00 | 2696
B | NC | TV Comm | 2024-08-31 00:00:00 | 2204
B | NC | TV Comm | 2024-09-30 00:00:00 | 4838
B | NC | TV Comm | 2024-10-31 00:00:00 | 2165
B | NC | TV Comm | 2024-11-30 00:00:00 | 4099
B | NC | TV Comm | 2024-12-31 00:00:00 | 1775
C | BD | Workshop | 2024-01-31 00:00:00 | 4914
C | BD | Workshop | 2024-02-29 00:00:00 | 4800
C | BD | Workshop | 2024-03-31 00:00:00 | 3468
C | BD | Workshop | 2024-04-30 00:00:00 | 4594
C | BD | Workshop | 2024-05-31 00:00:00 | 3125
C | BD | Workshop | 2024-06-30 00:00:00 | 1005
C | BD | Workshop | 2024-07-31 00:00:00 | 3650
C | BD | Workshop | 2024-08-31 00:00:00 | 3942
C | BD | Workshop | 2024-09-30 00:00:00 | 2872
C | BD | Workshop | 2024-10-31 00:00:00 | 2459
C | BD | Workshop | 2024-11-30 00:00:00 | 1412
C | BD | Workshop | 2024-12-31 00:00:00 | 1485
C | BD | Interest | 2024-01-31 00:00:00 | 2781
C | BD | Interest | 2024-02-29 00:00:00 | 2901
C | BD | Interest | 2024-03-31 00:00:00 | 3915
C | BD | Interest | 2024-04-30 00:00:00 | 4904
C | BD | Interest | 2024-05-31 00:00:00 | 2884
C | BD | Interest | 2024-06-30 00:00:00 | 1768
C | BD | Interest | 2024-07-31 00:00:00 | 2080
C | BD | Interest | 2024-08-31 00:00:00 | 2696
C | BD | Interest | 2024-09-30 00:00:00 | 1569
C | BD | Interest | 2024-10-31 00:00:00 | 0
C | BD | Interest | 2024-11-30 00:00:00 | 0
C | BD | Interest | 2024-12-31 00:00:00 | 0
C | BD | Advertisment | 2024-01-31 00:00:00 | 0
C | BD | Advertisment | 2024-02-29 00:00:00 | 0
C | BD | Advertisment | 2024-03-31 00:00:00 | 0
C | BD | Advertisment | 2024-04-30 00:00:00 | 0
C | BD | Advertisment | 2024-05-31 00:00:00 | 0
C | BD | Advertisment | 2024-06-30 00:00:00 | 0
C | BD | Advertisment | 2024-07-31 00:00:00 | 0
C | BD | Advertisment | 2024-08-31 00:00:00 | 2736
C | BD | Advertisment | 2024-09-30 00:00:00 | 3893
C | BD | Advertisment | 2024-10-31 00:00:00 | 3046
C | BD | Advertisment | 2024-11-30 00:00:00 | 1711
C | BD | Advertisment | 2024-12-31 00:00:00 | 4375