Aggr Max total

[demcug82]

Hi All,

i have a problem to calculate a KPI (text object).

This is the situation:

Dimension:

-Product

-Version

-Exception

I have to calculate the total count of exception (all products) but only in the last version of every product.

For example

Product 1 with version 1 (two exception), version 2 (one exception), version 3 (no exception)

Product 2 with version 1 (no exception), version 2( one exception), version 3 (one exception)

Product 3 with version 1(one exception), version 2( two exception)

The final value should be = 3   (1+2 of the product 2 and product 3)

I have tried with this:

Count(DISTINCT{1<[Version]={'$(=maxstring([Version]))'}>} Exception)

but works only if i select a product because calculate the count of exception of the last version of all product.

Any suggestions?

Thanks

Dem

[demcug82]

Sunny without distinct i'm passed from 5 to 53.

5 its' more small  but 53 too.

however when i select one product and last version the sum go to "Zero"  while i expect a value because there are exception.

[sunny_talwar]

Which product have you selected?