5 Replies Latest reply on Jun 22, 2015 7:41 PM by Monica Imatzu

    Display 0 counts for events that did not occur

    Tom Barry

      Hi All,


      First off, this is my first post in the Forums.  In order to make sure I'm not wasting anyone's time, I did do a thorough search of the forums to determine whether or not something like this has been posed before, and I didn't have any luck... so here goes.


      My objective is to show the count of product release by quarter, with quarters without the release of any products showing as 0.  I've attached a .twbx showing an example of my scenario.


      Currently, I'm only able to show quarters in a crosstab when a product was released during the months that define the quarter.  For example, in the attached .twbx, no products were released during Q2 (4/1/12 through 6/30/12) and therefore Q2 does not appear.


      Can anyone provide me with insight into how I can have Q2 appear with "0" on the crosstab?


      Thank you in advance for any guidance you can provide.