I am running a crosstab table for use in a report that shows sales history by month by item grouped by brands. My problem is when there were no sales in a given month, the month is not visible in the table. Below is a crude example:

Jan Feb Apr Jun Aug Nov Dec

You'll notice that Mar, May, Jul, Sep, and Oct are missing.

How can I get those months to populate the table showing zeros as data points?

Ok so now I have the AlwaysOne measure in my cube. How do I filter so that I see only the groups of, say, items that I want to see? Global criteria and selections on the Criteria Bar don't allow me to filter anything.

I was trying to filter on dimensions that were not in the crosstab itself. In other words my crosstab contained Items but I was filtering on Salesperson. I set a global criteria to a specific Salesperson but since Salesperson is not a dimension in the crosstab every Item in our system was shown regardless of who sold it.

To fix this I added Salesperson to the crosstab then using "Visibility" in the properties, I unchecked the Salesperson Name. That made the salesperson no longer visible but now I could set a criteria to filter a specific Salesperson.

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.