Problem with first dimension - pivot

[#1]

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.

[Anonymous]

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.

[reshmakala]

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.