Comparative Analysis Alternate State Aggr Set Analysis

[ivandrago]

Hi,

I have the attached Document which looks at the spreadsheet "Transactions.xlsx", I am trying to do the Alternate States using the CustomerNo field but the chart is not changing, the expressions within the chart using Set Analysis and AGGR so I'm not sure if my syntax is right?

Anyone know how to do this?

[sunny_talwar]

Try the attached may be

Sum({[Group1]} Aggr(Sum(DISTINCT {[Group1] <[Status] = {'Open'}, [CustomerNo] = [Group1]::[CustomerNo]>} [CreditLimit]), [Order No]))

Sum({[Group2]} Aggr(Sum(DISTINCT {[Group2] <[Status] = {'Open'}, [CustomerNo] = [Group2]::[CustomerNo]>} [CreditLimit]), [Order No]))