conditional fields in a picote table (I think)
 

maybe this is asking a lot.

but I'm trying to get a pivote table that looks like this.

"count of Ticket ID" MissCommit (0 or 1) %Made Commit

Month

so
Count of TicketID=the data area
Month=row area
MissCommit (which consists of 0 or 1) =Column area
and how do I make the %Made Commit?

%MadeCommit would be a "i guess" Conditional field based off of Miss
commit. (MissCommit=1/(MissCommit=1+MissCommit=0))

and then I'd like to make a chart which have the MissCommit(0or1) as a
stacked column and the % made commit as line graph.

so, that's the idea but I'm having problems in execution.

Any suggestions?

Thanks,
Alex