(http://s14.postimg.org/3poy4u8mp/xtabsample.jpg)
Can't you filter the data so that the null records aren't brought through?
Can't. The measures for the group in 'QR' will be affected.
QR and ST are separate queries which I just merged (join). This is 0..n - there are items in QR that are not in ST, thus the null on ST.
You can have items in the query that are not displayed on the report. Cut - instead of delete - the column you don't want and the data item will stay in the query.
Will this accomplish what you want?
no man. the column that i don't want to show is the null - this is not a data item in the query but rather a value of the data item 'ST'.
The only way I have been able to achieve this would be for you to not nest the second level under the first, that way you can add the conditional display on both groupings. So in your case you would be adding 'ST' 4 different times and having one item under each 'ST'
Did it! created data item calculation with the following expression:
Filter( [UV], [UV] in ( 'KL', 'MN', 'OP' ))
Sorry i have not cleared that 'ST' is not a data item but rather a crosstab space with 'ST' as its text just to label the header.
And let's just call 'UV' as the data item name which contains the values KL MN and OP
The expression above btw filters the values to be shown on that specific data item - not the whole query. Thus, not affecting the query results.