Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Please can I ask how I would get the results of the measure but across all dimensions (Mth-Year)?
Pivot Dimensions and Measure attached.
It is only showing within the first Mth-Year for which there was data for each authority.
With Thanks
Maybe try this
=Aggr(NODISTINCT Count(DISTINCT [Mth-Year]), [Authority ID])