I'm creating a bar graph summing sales over different business areas
In the spreadsheet, if the business areas are "A", "B", "C" and "Not filtered" how can I set up the bar chart so that it ignores Not Filtered values and doesn't display it as a category on the x-axis? (Without having to set up a filter panel each time, preferably something with the dimension function)
First expression will always show all three Business Area regardless of selection in BusinessArea field. Whereas second option will filter out those which are not selected while always excluding Not Filtered.