Cross table, using If statement adding extra column at end, want to remove.

[former_member618551]

I have a cross table, at the first row is the header of years, it is using a If statement: =If(Month([ABCDEFGH])="December";FormatNumber(Year([ABCDEFGH]);"####")). It is always insert a column at the very end with no value. I'm thinking in the If statement if the condition is not met(false) then it shouldn't display anything? which is what I want If the condition is not met(false) then don't show a column. Can someone please help? Thanks.

[denis_konovalov]

As you haven't mentioned what tool you are using, I have fixed your tag to reflect most probable scenario.
Please select more careful and be more descriptive in your questions.

[daniele_tiles2]

Hi Hao,
I think that there is no data in the header (as you pointed out, the clause is false), but the problem is that there is (I guess) some data in the variable used inside the cross table.

My suggestion is to:

1. Turn the formula you've create into a variable
2. Filter the cross table for the variable where is not null

That should work (not clear what you are trying to achieve, though).

Hope that helps

Daniele Tiles