BOXI R2 - Weighted Average in a cross tab multiple mos.

I am trying to create a rolling 12 month report.

Rows are Dimension [Asset Type]

Columns are Measure [Value] and [v_% of Total]

Do I need to create a query for each month to avoid #MULTIVALUE in the [v_% of Total] cell?


LaurenBOXI :us: (BOB member since 2009-09-15)