IIf criteria - return no change to orginal value of a field

[mirirom]

heya,

i have a crosstab query that has a grouping function (Partition) assigned to one of the row headers; works fine. however, i'm trying to implement a IIf statement on another row header field which is based upon the value of a group segement. unfortunately, the query won't return the "condtional" group now.

for example, the query shows Name, Boolean, BilledAmount as row headers. 2 dynamic date values are then used for Months as column headers.

i have the following IIf statement under the BilledAmount criteria:
IIf([Boolean]=0,0,[BilledAmount])

without this statement, the querry will return 1 line of data for each of the -1 & 0 values with BilledAmount showing duplicate values. with the statement, only the rows with a -1 (True) value are returned. idealy, i'd like the query to run showing a row for each -1 & 0 value with BilledAmount showing 0 if Boolean = false.

is this possible?

 

[mirirom]

figured it out. the statement is entered in the field name, NOT the criterea.