I am working on a crystal report the source is Bex query and version of crystal report is 4.1 SP3. In my structure (which has a hierarchy) I have both receipts and expenditure. I want to separate Receipts and Expenditure.
My data is as below,
Now I want to get Receipts 1,2 and 3 apart from expenditure 1,2 and 3. How to create a formula based on the structure so that I could get them differently. I tried to use hide option in the formula only one receipt/expenditure(1,2 and 3) gets hidden even though I select more than one of them.