Forum Discussion
Hierarchy Subtract
Hello. I'm having a table with a field Version, up to now it only holds 2 values, 1 or 2 (this is used to compare measures). But I would now like to define a 3rd value that subtracts the 2 values f...
A little more details would be great
Ok, let say this is the table, this table is used in a filtering system where users can compare 2 versions of a complete set of facts. There is a many-tomanu relationship (intermed table) on SelKey to the facts.
I would like to be able to create a calculated 'version' (ex) 3 that has the formula CompVersion-Value-1 minus CompVersion-Value-2, but that should work on all KPI's. Creating a Hierarchy on Compversion with a element above would sum both, I would like to subtract one ...
| CompVersion | SelKey | Dim1 | Dim2 | Dim3 | Dim4 | Dim5 |
| 1 | 1 | Plan1 | XX | OK | 01/02/2018 | |
| 1 | 2 | Plan1 | XX | OK | 02/02/2018 | |
| 1 | 3 | Plan1 | X123 | 01/02/2018 | ||
| 1 | 4 | Plan1 | XY | NOK | 01/02/2018 | |
| 1 | 5 | Plan1 | XY | NOK | 02/02/2018 | |
| 1 | 6 | Plan2 | ZZ | 01/03/2018 | ||
| 1 | 7 | Plan2 | ZZ | 02/03/2018 | ||
| 1 | 8 | Plan3 | ZZ | 01/01/2017 | ||
| 1 | 9 | Plan4 | 01/01/2018 | |||
| 2 | 1 | Plan1 | XX | OK | 01/02/2018 | |
| 2 | 2 | Plan1 | XX | OK | 02/02/2018 | |
| 2 | 3 | Plan1 | X123 | 01/02/2018 | ||
| 2 | 4 | Plan1 | XY | NOK | 01/02/2018 | |
| 2 | 5 | Plan1 | XY | NOK | 02/02/2018 | |
| 2 | 6 | Plan2 | ZZ | 01/03/2018 | ||
| 2 | 7 | Plan2 | ZZ | 02/03/2018 | ||
| 2 | 8 | Plan3 | ZZ | 01/01/2017 | ||
| 2 | 9 | Plan4 | 01/01/2018 |