Forum Discussion
Filter on multiple Columns / Values - Data Consolidation
Hi All, i´m struggeling to create a Costcenter Report, where some kind of consolidation has to be done. Attached you can see some sample data. What i want to achieve is: If a User selects...
COSTCENTER AMOUNT MONTH SOURCEOBJECT COSTELEMENT CONSOLIDATION HIERARCHY
43960654 92531,88 1 43960552 6600250000 TOTAL_COSTS
43960654 52374,15 1 43960551 6600250000 TOTAL_COSTS
43960654 406388,97 1 6600260000 TOTAL_COSTS
43960552 736 1 43960654 6520000001 TOTAL_COSTS
43960552 684,54 1 43960655 6520000016 TOTAL_COSTS
43960552 91111,46 1 4020110000 TOTAL_COSTS
-92531,88 1 43960552 8888888888 43960654-43960552 TOTAL_COSTS
92531,88 1 43960552 9999999999 43960654-43960552 CHARGES
-52374,15 1 43960551 8888888888 43960654-43960551 TOTAL_COSTS
52374,15 1 43960551 9999999999 43960654-43960551 CHARGES
-736 1 43960654 8888888888 43960552-43960654 TOTAL_COSTS
736 1 43960654 9999999999 43960552-43960654 CHARGES
-684,54 1 43960655 8888888888 43960552-43960655 TOTAL_COSTS
684,54 1 43960655 9999999999 43960552-43960655 CHARGES