Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I'm having a problem while creating a pivot table.
lets say I have the following table:
ID | Is Main Activity | Parent ID |
---|---|---|
1 | Yes | Null |
2 | No | 1 |
3 | No | 1 |
4 | Yes | Null |
5 | No | 4 |
I have Hierarchy Pivot table. The firs Dimension Is the ID (Lets Say "1").I want that the condition will be (if (Is Main Activity=Yes, Parent ID)),
The Next Dimensions contains all the children of 1 (2,3). the problem is that they have "Is main Activity = No" so they are not display on the pivot table.
Does someone have any idea of how to fix this?
Thanks.
Hi Michal,
I don't undestand where you want to insert the condition (if (Is Main Activity=Yes, Parent ID)).
Can you post your expected output?
Thanks.
Your if statement (if (Is Main Activity=Yes, Parent ID)) is just a if-then statement so you cannot see the rows not satisfying the condition. Put some else condition to see those rows.