Crosstab cannot display all the values

[Eugene]

Deal all,


I have a data module which contains 5 data sets. From these 5 tables I create a Union Table.
Then  I use this data module as a source for a Dashboard. I go to dashboard and create a crosstab from the union table.
But when I am using a data item at the crosstab, I cannot see all the values of this data item.
Also I go and create a list at the dashboard and use the same data item and all the values appears.   

Do you know why this is happening ?

Thanks in advance.

[so10070]

I have the same problem with datasets, not with the uploaden Excels (= a former form of my dashboard it worked well).  And not all sets geven this problem. Even don't know why?

[so10070]

I have found the solution for this problem on my dashboard.  I set the value on the numeric field (characteristic "summarize") to "sum" and my values appaers.