TIBCO Spotfire

 I have a crosstab with Binned columns and the "Binning" is defined by specified limits.The data is available for say 3 limits in the totally specified 5 limits.

 I need all the 5 columns to be rendered even when the data is available for only 3 columns.

Please help me on this.

 Render the cells, row by row and grouped in appropriate columns like natural adabas between the ..... column five (1*) will receive one, and column six (3*) will receive three. 

Not sure if this will work but...

Right-click the crosstab and go to properties, then select axes. The resulting window should show your columns selected for horizontal, vertical, and cells.  Clicking the "settings" button for either of those brings up a new window with a drop down for "show filtered values" or "show all values" -- this basically drives which column headers to include. Try selecting "show all values".

If that doesn't work, I'd guess that you don't have any data in the dataset with values that would fit in the missing bins. To correct for this, you could add a few dummy rows to your data set to make sure you had at least one value for each bin, then give them a "dummy" flag that you can turn on or off in filters, then make sure the "show all values" drop down is selected per the paragraph above.

Let me know how it goes!