Table chart problems.

[sevvalk]

Hello,

In the report I prepared, for example, I filter orders with status A in the 1st week of 2024. In the "reamount" column, I write the quantities to be produced in orders, I filter the ones with ">0" in the "reamonut" dimension with a button and list them in a table. However, if there is no order with reamonut>0, it removes the 2024 selection. My report is working incorrectly. How can I fix this? If there is no data according to these filters, an empty table should appear.

[Cascader]

if your report is deselecting the '2024' selection when there are no orders with remamount>0 , it's likely due to how the filtering action is set up in your button. To resolve this and ensure that an empty table is displayed instead of changing the year selection

[Or]

Two options here:

1) Lock the year selection

2) Disable the button if pressing it would result in no rows being returned with the current selection. The enable condition might look something like:

Count({< reamount = {">0"} >} OrderID) >0