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...
Hi all,
unfortunately i was still not able to find a solution.
Maybe it´s even not possible to create such a measure.
I still hope that someone can help us for this topic.
I´ve uploaded some sample data.
Best Regards
| 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 |