Hiya All
Something New...Loops
I have the following in a script and want to loop and say
Per Dimension Count ( Distinct(Acct)) where Dimension is greater than 0
The following numbers below are field names not values, although they contains values.
I am inner joining this to a Group
So example
LOAD Acct,
[0],
Count(Distinct(Acct)) where [0] > 0 as Current Month
[1],
Count(Distinct(Acct)) where [1] > 0 as Month1
[2],
[3],
[4],
[5],
all the way to 72!
