Show all dates, regardless of selection without aggregation

[JustinDallas]

Hello Everyone,

So here is my problem.  I have a chart where there are Territories, and BillingDayInMonth.  The Territories are linked to BillingDays by their being an Invoice on that BillingDay.  This creates the issue of not every Territory having an Invoice on every BillingDay, so my chart looks sparse with some BillingDays being skipped.  I've attached a picture.

What I would like to do, is that even if a Territory doesn't have a BillingDay link, just show zero in the columns.  Keep in mind, that just because Territory A doesn't have a link to a BillingDay of 2, it doesn't mean that Territory B doesn't.  So the data most likely has all of the BillingDays, just not down to the Territory level.

(How do I get a :"2" between the 1 and 3 for the Canada East territory?)

Now if this was an aggregate such as SUM or something, I could use TOTAL.  But an aggregate over the BillingDay doesn't make much sense to a noob like me.

Any help is greatly appreciated.

[MK_QSL]

You need to associate 0 values for days where Territory don't have values.

This can be done in script side. In case, if you provide sample data, would like to do for you.

[JustinDallas]

Apparently, I've run into this problem before and didn't remember the solution.  The solution to my problem will resemble something like this.

How to fill in sparse production dates.

[MK_QSL]

There is a blog from HIC on filling missing values which you can search from community... There you will find similar kind of example....