I have a view where I show the number of total incident tickets for a quarter and the number of incident tickets per Core Service. I want the total number to remain unchanged when I filter the view by Core Service. So I have an LOD expression that goes like this:
Trouble is... my FY16Q4 Qtr total value is still changing when I filter by Core Service:
I'm using an ODBC connection to ServiceNow and am appending historical data from a different system. The core service names did change in this quarter. But the Core Service filter does work correctly when it's used elsewhere.