How to ignore selection in filter

daria — Sat, 16 Nov 2024 17:53:55 GMT

Hi All,

I have source data like this:

SourceData: Load * inline [SetName, Date, Type, Value 'A', 30/10/2020, 1, 1 'A', 26/10/2020, 1, 2 'B', 30/10/2020, 1, 3 'B', 26/10/2020, 1, Null 'C', 30/10/2020, 1, 2 'C', 25/10/2020, 1, 3 'D', 25/10/2020, 1, 4 'A', 30/10/2020, 2, 4 'A', 26/10/2020, 2, 3 'B', 30/10/2020, 2, Null 'B', 26/10/2020, 2, Null 'C', 30/10/2020, 2, 1 'C', 25/10/2020, 2, 5 'D', 25/10/2020, 2, 2 ];

I use pivot table to display Sum of Values by Type for each SetName :

Also I have a filter by Date. But I want to see ALL values for SetName regardless of the selected Date in the filter. I just want to see static 'A, B, C, D,' in SetName and different measure values or 'Null' if there are no values for specific date.

Is it possible? Does anyone know how to do this?

Re: How to ignore selection in filter

rubenmarin — Sat, 31 Oct 2020 12:08:59 GMT

Hi @daria , try setting as expression Sum(Value)+Sum({1}0)

topic How to ignore selection in filter in App Development

How to ignore selection in filter

Re: How to ignore selection in filter