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!