Hi,
I am doing a sectioning on a data item say Country .then my cross tab shows me data for each country sectioned with sales by state present in the country. I have used suppress zero on rows and columns on my measure . My issue is whenever there is no sales in any of the country, it just shows the sectioned heading which is the country name and says no data available below.
How can I remove this country with no sales and not to be displayed on my report.
Thanks,
use filter. take out countries with sales = 0