The query below returns the sample variance for Sales Amount across all State-Province members using the biased formula.
|
|
WITH MEMBER [Measures].[Vp] AS VARP([Geography].[Geography].[State-Province].Members, [Measures].[Sales Amount])
SELECT {[Measures].[Vp]} ON COLUMNS
FROM [Adventure Works]
|
|
|
|
|
|
|