May 15, 2014

Sub Average in cross table on spotfire

[USER_ID] NEST [NETWORK] NEST Sum([Amount]) over ([USER_ID]) / UniqueCount(if([NETWORK] is null," ",[NETWORK])) over ([USER_ID]) as [Avg]