Hi All,
I have below data which is actually a report and I have pulled some sort of data from it, now the demand is to make a dashboard only basis on this report and we can not make any change in the excel format anything required to change only would be possible in qlik sense itself.
I want to add a separate column of highlighted total values so that I can make reports accordingly. Please advise
| Item | Jan | Feb | Mar | April | May |
| Salary/Wages Indirect | 5,14,214 | 4,51,369 | 5,17,410 | 5,35,808 | 5,84,182 |
| Overtime Scheduled Indirect | 5,432 | 38,903 | 43,445 | 43,618 | 6,524 |
| Overtime Unscheduled Indirect | 1,27,150 | 91,904 | 1,06,206 | 81,006 | 1,28,165 |
| Indirect Labor Benefits | 2,39,315 | 2,15,405 | 2,46,812 | 2,44,360 | 2,65,983 |
| Temporary Indirect Labor | 20,626 | 10,017 | 20,251 | 19,198 | 19,292 |
| Total Indirect Labor | 9,06,737 | 8,07,599 | 9,34,124 | 9,23,989 | 10,04,146 |
| COGS Depreciation Expense | 6,33,605 | 6,34,466 | 13,54,598 | 15,03,639 | 15,43,900 |
| Total Depreciation | 6,33,605 | 6,34,466 | 13,54,598 | 15,03,639 | 15,43,900 |
| Utilities Electric | 5,39,376 | 5,40,216 | 5,63,378 | 6,76,848 | 7,11,619 |
| Utilities Gas | 91,725 | 63,051 | 2,51,678 | 1,36,104 | 1,02,884 |
| Utilities Water/Sewer | 1,51,757 | 2,25,980 | 1,46,552 | 1,97,443 | 2,29,718 |
| Utility Expense | 7,82,858 | 8,29,246 | 9,61,609 | 10,10,396 | 10,44,222 |
| Waste Disposal | 5,168 | 10,206 | 32,121 | 58,103 | 24,894 |
| Dust Handling | 3,28,349 | 3,47,651 | 3,97,718 | 4,97,120 | 5,06,260 |
| Poly Handling | 0 | 0 | 0 | 0 | 0 |
| Intraplant Freight | 0 | 0 | 0 | 0 | 0 |
| Contract Services Other | 49,633 | 32,783 | 58,239 | 48,059 | 88,956 |
| Professional Fees Consulting | 0 | 0 | 8,750 | 0 | 0 |
| Contract & Professional Servic | 3,83,150 | 3,90,640 | 4,96,827 | 6,03,282 | 6,20,110 |
