I definitely need help on this one...Not thinking straight

[MrHelpMe]

Hello,

I'm going to try and explain this as best as I can. Using Crystal ver 8 and have created crosstab.
Now in my rows I have transactionTypeCode and @Name
TransactionTypeCode = Buy, Sell, Tri, Tro
Name formula is as Follows
if {V_AIC_SALES.OriginCode} = &quot;DIR&quot; and {V_AIC_SALES.RedemptionCode} <> &quot;RESPGA&quot; then &quot;MANUAL&quot; else
if {V_AIC_SALES.OriginCode} = &quot;TRK&quot; then &quot;ROLLOVER&quot; else
if {V_AIC_SALES.OriginCode} = &quot;WOR&quot; then &quot;WOR&quot;
Columns I have PlacementDate(is April 2003...I grouped by month).

The problem is as follows. I set the summarized field to do a count on @Name, however I'm not sure why I'm getting values back especially under the situation if {V_AIC_SALES.OriginCode} = &quot;DIR&quot; and {V_AIC_SALES.RedemptionCode} <> &quot;RESPGA&quot; then &quot;MANUAL&quot;. Currently, when the name row is showing Blank, values are showing something. I need the report to only show

Apr May June
Buy Manual 5 1 6
Wor 6 2 2
Rollover 7 3 1

But remember I only want to show manuals and count it when
if {V_AIC_SALES.OriginCode} = &quot;DIR&quot; and {V_AIC_SALES.RedemptionCode} <> &quot;RESPGA&quot; then &quot;MANUAL&quot;
Everything else will remain the same. This is the only special formula.
Hope this makes sense