Ignore Selections

nchamilton162 — Wed, 29 Mar 2023 16:16:39 GMT

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

Re: Ignore Selections

BrunPierre — Wed, 29 Mar 2023 19:15:43 GMT

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

topic Re: Ignore Selections in App Development

Ignore Selections

Re: Ignore Selections