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.
Tom
This is easy in v7 and higher:
- Right-click any quarter label, tick "Show missing values" to display Q2
- Right-click any value in the grid, select Format from pop-up menu to format your measure
- In Format panel on the left specify how you want to display nulls.
