Expression total showing incorrect?

[#1]

Hi,

I have straight table as below. When I made expression total it is not showing the count of ID correct. It is missing some records count. can anyone suggest me about this please?

Dimension	Count(StudentID)
	167
2nd class	45
3rd  class	12
4th class	34
5th class	78

Thanks.

[its_anandrjs]

Update:- You have to use Sum of rows because the expression total always give wrong values check the attached snap shot.

If you want to get Total then use

Try with

Count(StudentID)

And from chart properties >> Expressions >> Sum of rows instead of expression total

See the snap shot

[amit_saini]

Hi Ameila,

In Total mode option please select as Sum

Thanks,

AS

[jfkinspari]

Or you might want to change to total mode to 'Sum' of rows

[MK_QSL]

Aggr(Count(StudentID),Dimension)

[stabben23]

Hi,

or use the qualifier count( total <Dimension> StudentID).

[er_mohit]

I think uncheck suppress zero value from presentation tab

or uncheck suppress when value is null from dimension side

[preminqlik]

use the following expression :

sum(aggr(count(StudentID),Dimension1,dimension2))

[#9]

To get the correct total of all rows, you should use the Sum of rows option instead of using Expression total.