filter only positive values

[#1]

Dear all,

i have the pivot table like

Type    subtype  Company     XXX     YYY     ZZZ     AAA     BBB

  A          ---                 100     120     230     322     223

  B        ----                    -20     22     31          13     32

  C         ---                   -100     21     23     434     34

i need to show the table only those type C is positive. also i need to show the A and B as well. in this ex i have to exclude the XXX Comp.

I have sub type also. but i have to consider only type =c.

for type A is having the subtype a1,a2,a3. similayly for B also. but c is not having any subtypes.

Could any one help me ...

[rahulgupta]

Hey Hi,

Kindly check out the Application attached and revert back for further issues(if any).

Regards,

Rahul Gupta    

[alwinsch]

Hi Rahul,

I saw your example and it helps with my problem.

But how did you do this?

can you convert the '-'  for column XXX to value 0?

Thanks.

Alwin