Remove rows from straight table based on conditions

[#1]

I'm trying to remove rows from a straight table where particular conditions are met. In the attached QVW take a look at record with an "ID Code" of 1001. You will notice that that this ID appears twice in my straight table. I'd like to make it so that the first instance of the record is removed assuming the proper conditions are met.

That is:

IF Field = 'AsscSpouse_Initial1'

AND Column 1 = 'F'

AND Column 2 = 'NULL'

...then remove that row....

Any ideas?

[Oleg_Troyansky]

Tom,

looking at your calculated dimensions, I clearly see that you are having way too much fun with nested IF() functions. Your Column1 and Column2 are perfect candidates for creating a mapping table and calculating them in the load time (not in run-time). Once you have those two dimensions as Fields and no other IF() functions, you could use a single IF to eliminate unwanted rows - under certain conditions, return a null() as a Dimensions' value and then check the checkbox "Suppress when value is null".

Remember that each and every IF() function within Calculated Dimensions and/or within the aggregated functions, will be evaluated for each row in your data table, adding a LOT of performance hurdles. Nested IFs only make the problem worse....

cheers,