Count Distinct Exclude Total Row

[#1]

I have a chart with a total row.  When I execute the =count(distinct(field name)) the total includes the row with the totals.  Is there a way to eliminate the total row in the count?  Thanks.

[sunny_talwar]

Not sure what you mean, but try this:

Sum(Aggr(Count(DISTINCT FieldName), YourChartDimensions))

[#3]

Thanks, but that did not work.  Here is an example.  There are 8 invoices but the count = 9.

[sunny_talwar]

Is Customer Name and Inv Nbr the only two dimensions in this chart? and when you did this, it did not give you the correct total up-top -> Sum(Aggr(Count(DISTINCT FieldName), [Customer Name], [Inv Nbr]))?

[#5]

There are 8 dimensions in the table.  I used Sum(Aggr(Count(DISTINCT [Invoice Number]), [Invoice Number]))  since I'm trying to determine the invoice count.

[sunny_talwar]

Try the above expression by adding all dimensions in it and see if it gives you the desired output.

[#7]

It gave me a count of 20

[Gabriel]

Hi,

If you have Primary Key in your data model I suggest count the Primary key.

Like ID sort of

[avinashelite]

Share your sample app and data will see whats the issues is

[PrashantSangle]

Hi,

Are you selecting Supress when Value is Null option from dimension tab.

Regards