Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a table with some data. All data have a creation date field. So i display in a table all my data create by month with the creation date with a count.
Jan. 2011 Feb. 2011 Mar. 2011 . ... Nov. 2011
CountCreate: 2 8 12 ... 6
But for exemple; there is no data in December or in April; So the table will not display the month in the table. But i would like to display it even if there is no data.
Jan. 2011 Feb. 2011 Mar. 2011 . ... Nov. 2011 Dec. 2011
CountCreate: 2 8 12 ... 6 0
Is it possible to do that in the table and the chart ?
Thanks by advance
I got it ...
In fact, i replace: =if(month([Date création DCP]), MMYYYY) by MMYYYY
and
I unchecked:
- Delete if nul values (in Dimentions)
- Delete nul values (in Presentation)
- Delete missed Values (in Presentation)
- Display all values (in Dimentions)
that's all