Data Cleansing

[sunil-kumar5]

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

[A7R3]

This article may help.

https://community.qlik.com/t5/Qlik-Design-Blog/P-amp-L-Pivot-Chart-Extension/ba-p/1615671