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?

Revenue_View_88037.PNG

Accepted answers

All comments

otalpur

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?

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?