Essentially I have a packaged wb attached that has some sample concert attendance data. There are 2 sheets : summary view and logistics. On the logistics sheet, I have a field called logistics added to filter. However what I would like to be able to do is to display a zero (for the concert id calc field) when the "global logistics" value is not selected in the filter. I've tried several approaches- ZN(), ISNULL(), IFNULL() with no success. Any guidance you can provide would be tremendously appreciated.
thanks guys.
Mike
sorry but the data set you provided does not seem to reflect the problem - all countries have values - in your real data set if you are experiencing a problem where there is no-record for a country /city/concert combination and you plan to filter to that level you will need to scaffold the data to fill out the data set - this post https://jimdehner.com/2021/02/19/faq-series-when-and-how-to-scaffold-data/ explains how voids and sparse data affect the calculation - the 3rd example will detail the problem you face - -- the blog is also on video at https://youtu.be/uUgXnWJ2iEs
