I have one chart in that have null values when i am doing sorting on YTD basis the entire null values come in first row.
I want that entire null values will be place in last row other wise i want to hide null records but my total value don't get effect.
If your Null values are real Null (and not missing values) you can manage them
- in the script with NullAsValue and NullValue instructions.
- In the chart with the Suppress Null Values CheckBox