Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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