Missing rows in pivot tables

[Cindy821]

Hello,

I am working on an App containing two pivot tables.

Source of data contains around 290 rows.

When data is inserted into pivot tables as dimensions, it turns out that there are quite a no. of rows went missing.

I am having a hard time to understand this.

I checked that 290 rows (excel file) were correctly loaded into the App..

Could you please help me on this?

Thank you

[GaryGiles]

When you say missing rows, how are you determining that rows are missing?  When you add a dimension to a pivot or straight table, it will show the unique values for that dimension (or group of dimensions).  If a dimension only has 10 unique values, you will see 10 rows, not 290.