Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
change your 2nd expression to:
=count( total <PartName> Key)
it will give you a subtotal on PartName. 6 on first row, 7 on 2nd.
change your 2nd expression to:
=count( total <PartName> Key)
it will give you a subtotal on PartName. 6 on first row, 7 on 2nd.
Hi,
Use TOTAL to ignore the dimension which is simlar to Group by in SQL
=Count( TOTAL <PartName> Key)
Regards,
jagan.