Help Needed for Calculated Dimension/Set Analysis

[#1]

Hi, I would like to write a set analysis in which I can create a new column called AllChange. It would be great if this can be done with calculate dimensions instead of the script. So, if the price changed for all products in that specific type, then "yes" in the AllChange column. If you look at the sample data below, A is all "yes" because all products within that type changed in price. For Type B, product 2 did not change in price and therefore AllChange for all products within Type B would be No.

Original Table Structure:

Product          Price Change          Type

1                    $10                          A 

2                    $15                          A

3                    -$30                         A

4                    -$40                         A

1                    $20                          B 

2                    $0                            B

3                    -$18                         B

4                    -$20                         B

New Table Structure

Product          Price Change          Type     AllChange?

1                    $10                          A            Yes

2                    $15                          A            Yes

3                    -$30                         A            Yes

4                    -$40                         A            Yes

1                    $20                          B            No

2                    $0                            B            No

3                    -$18                         B            No

4                    -$20                         B            No

I look forward to any assistance I can get. Thank you for your time!

[sunny_talwar]

May be this:

=If(Sum(TOTAL <Type> Aggr(If([Price Change] = 0, 1), Product, Type)) > 0, 'No', 'Yes')