If I understand correctly, you'd like to show
All Accounts value (the same one for each User)
in every Year / Quarter combo cell on a view.
This would need a kind of data densification,
ie creating Marks for those Dimension values
combinations not present in the datasource.
One could trigger such a densification on a view
by using a Table Calculation -- such as WINDOW_MAX() --
instead of a simple Aggregate calculation.
The other trick to have a view as needed
is not Filter NULL values of a [Date] field,
but Hide them instead.
Please find the attached.
Hope it helps.
Test Workbook_YF.twbx 54.7 KB
I got to the point where I included the Nulls in date filter and told the users that you would see the count in Null column if there are no calls in the selected dates.
But this solutions works great, won't need any user training now