Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone please help me figure out how to ignore specific selections in a straight table.
Objective: show all Managers and allow the user to select all expenses for YearQuarter 2023-Q1. If they don't have any expenses for that quarter, I still need to show their Name, their expense amts will just show 0 (I have other fields I may add to this straight table). I would like to prevent hard coding any selections in a set analysis (such as Manager = Y, yearquarter = 2023-Q1).
Using the following example. I would like to show all Names even if they didn't have any expenses in 2023-Q1. I want the user to be able to select 2023-Q1 from a filter and Manager= Y from a filter and at least filter down to that year/quarter for only Managers.
Example:
Name YearQuarter Rank Expense Manager
Name1 2023-Q1 1 500 Y
Name1 2023-Q1 2 100 Y
Name2 Y
Name3 2023-Q1 0 Y
Hello, as far as I understand, you can use;
Sum(TOTAL <YearQuarter, Manager, Dim3> Expense) //This ignores any dimensions not specified
+
Sum({1} 0) //This displays Names with zero values