Dimension not showing all values

[bobbydave]

Country	Value
AT		1
BE	2

I have a table where it should be showing multiple values for Country but is showing as above.

The correct table should show something like below

Country	Value
AT	1
AT	2
AT	3
BE	4
BE	5

Anyone any ideas why it doesn't appear this way?

[alexandros17 · Accepted solution]

What kind of object did you use?

Tell us about dimension and expression used?

Are you sure that data is correcly loaded?

[Anonymous]

post some sample data

[bobbydave]

I used a pivot .

I changed it to a table and it worked