Hi all ,
I have one issue in my data
I have two tables like below ,
Tabl:
LOAD * INLINE [
ID, Sub ID, Val
1, 1.1, 873
1, 1.2, 9267
1, 1.3, 28
2, 2.1, 6726
2, 2.2, 6725
3, 3.1, 78
3, 3.2, 7256
3, 3.3, 2678
];
Tab2:
LOAD * INLINE [
ID, Val 2
1, 893
2, 9038
3, 7823
];
Second table is linking with ID only .But i add these two fields sum in straight table with ID, Sub ID as dimensions and Val and Val 2 as Expression
For Val 2 i don't have bifurcation for Val 2 against Sub ID. Bcoz of that reason val 2 is geeting repeate all over.
I m planing to some like below : Is that possible
| ID | Sub ID | Val 1 | Val 2 |
| | | 33631 | 17754 |
| 1 | 1.1 | 873 | 893 |
| 1 | 1.2 | 9267 | 0 |
| 1 | 1.3 | 28 | 0 |
| 2 | 2.1 | 6726 | 9038 |
| 2 | 2.2 | 6725 | 0 |
| 3 | 3.1 | 78 | 7823 |
| 3 | 3.2 | 7256 | 0 |
| 3 | 3.3 | 2678 | 0 |
