Crosstab with multiple measures based on rows

[thart21]

I need to build a crosstab report and cannot seem to find anything similar to my situation.

                               
Rows                      Row Qtys      Addl measure
Confirmed                                      Confirmed $
Shipped                                         Shipped $
Received                                        Received $

Is there a way to define the "Addl measure" for each row? I am working on trying a calculated column with an "If" statement but running into validation errors with that.

Iif ([Confirmed Qty]>0 then [Query1].[Confirmed $] else if [Query1].[Shipped Qty]>0 then [Query1].[Shipped $], else if [Received Qty]>0 the [Query1].[Received $])     

Would appreciate any point in the right direction, thanks!