grouping problem in crosstab

[shivareddyk]

hi guys,

 

my source data look like this

 

field1     field2   field3   measure

a            f            null           423

b            g          null            645

c             d           qwe         678

 

when i am displaying data by usng crosstab,i am getting only

 

c    d   qwe   678

 

Question? how we can display the remaining 2 rows also in crosstab?(only the problem i-reports crosstab),i hope the problem with crosstab grouping,am i rite?

(note: when i am  use same mdx query in mondrian schem i am getting all rows)

I hope some one help on this issue

 

Thanking u in advance....

 

[shivareddyk]

any idea to fix the above issue?