Is account year nested in the cube design? If so can you set it as a
dimension on its own?
On 7/6/2011 9:21 AM, vijay kumar wrote:
> I am using cross tab to display my result. my resilt returns 6 rows. in that one row is having value for for one field and remaing fileds are null. I have attached the screen shots of what am i doing.
> some one help me. thank you in advance
> Thank you
> vijay Kumar Bolisetti
What do you want your output to look like? If you have a value in one column of a row, but not for the others, it's going to be blank. If you don't want it to just be blank, then in the text box in the 4th screenshot in your DOC file, put what you want it to show when there are "null" values.