Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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]))