Year Total Showing Before Quarter


I have not had this issue before (or at least I don't think I have), but I created a revenue view and the year totals show before the quarters. I'm not sure why. I checked some other models I've worked and this isn't an issue.


I have not "selected items to show" on time so that's not an issue.

There is no sort on the columns.

The filters only have time filters and removing them doesn't change anything.


Is this a known bug/workaround that I'm missed or has anyone ever else ran into the problem?


  • So after posting this, I was able to resolve this by pivoting the time into rows as a nested dimension and then pivoting it back to columns.
    Anyone have an idea of why this would have occurred?