Set Analysis Not Working

[#1]

Hi,

Please take a look at the attached qvw file. In there I have an expression named: Total #Parts with a set analysis defined in it. The idea is this expression, for each PartName, to display the count for all PartColor values.. So for example for the first row I want the expression to display 6 (2+4) and for the second row it should display 7 (4+3). But instead, it is displaying the same data as #Parts expression. Why is that the set analysis not working as expected here?

[JonnyPoole · Accepted solution]

change your 2nd expression to:

=count( total <PartName>  Key)

it will give you a subtotal on PartName.  6 on first row,  7 on 2nd.

[jagan]

Hi,

Use TOTAL to ignore the dimension which is simlar to Group by in SQL

=Count( TOTAL <PartName> Key)

Regards,

jagan.