Straight table not showing values correct?

[#1]

Hi,

I have a straight table which is getting data from excel sheet.  in the excel I have three Members. But in the straight btable it is showing only two members. Please can any one help me?

Thanks.

[#2]

Please see attached.

[#3]

Please see attached excel also

[its_anandrjs]

Your straight table is not properly visible click on last and drag it down. Third row is not visible arrange your straight table then it will visible to you and data is right.

Hope this helps

[#5]

Thanks. But the data is not correct for member 'Sein' as in excel the count for 'Sein' is 21. There are two instance of IDs S02146 with different dates. this is the problem. How can I show two IDs by using Distinct?

[jsingh71]

It's Showing correct data for me. I didn't verified through excel but it showing all three members for me.

Find attachment.

--Jai

[#7]

Thanks. It is showing correct when I use Date or ID in straight table. But I don't want to use Date or ID. I just need the count. Please help.

[jsingh71]

Tell me dimensions and expressions what you want to show in your report.

--Jai

[#9]

I want to show

Dimension: Member

Expression 1(Number Review):

Count({<[Overall Result]={'Fail'}>} Distinct ([ID]))+

Count({<[Overall Result]={'Pass'}>} Distinct ([ID]))

Expression 2(Fail): Count({<[Overall Result]={'Fail'}>} Distinct ([ID]))

Expression 3(% of Fail): [Fail]/[Number Review]

[arjunkrishnan]

Hai Amelia D,

Now All Three Member Show The Output In Straight Table ... U Just Check It out