Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I show only all values for the first dimension (Month Year)?
So not the blank line for product. Anyone an idea?
Product | Jan 2011 | Feb 2011 | Mar 2011 | Apr 2011 | May 2011 | Jun 2011 | Jul 2011 | Aug 2011 | Sep 2011 | Oct 2011 | Nov 2011 | Dec 2011 | YTD | ||
LU | A | 7.216858 | 7.583258 | 10.340433 | 8.358783 | 8.715024 | 16.269748 | 9.410067 | 7.389933 | 15.634753 | 8.839987 | 8.697835 | - | 108.457 | |
LU | B | 32.560003 | 36.131143 | 54.019647 | 41.12253 | 39.513917 | 67.145325 | 44.320706 | 51.745736 | 50.433456 | 36.962266 | 39.286778 | - | 493.242 | |
LU | C | 13.815382 | 15.014906 | 18.960752 | 16.847954 | 17.859494 | 22.402191 | 19.136007 | 15.601053 | 21.030252 | 20.574516 | 21.07878 | - | 202.321 | |
LU | D | 74.929977 | 53.786508 | 69.15376 | 107.4101 | 55.193422 | 70.519295 | 59.561149 | 51.773601 | 66.394184 | 46.546604 | 56.75234 | - | 712.021 | |
LU | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
Act | A | 7.216858 | 7.583258 | 10.340433 | 8.358783 | 8.715024 | 16.269748 | 9.410067 | 7.389933 | 15.634753 | 8.8255 | 8.968197 | - | 108.713 | |
Act | B | 32.560003 | 36.131143 | 54.019647 | 41.12253 | 39.513917 | 67.145325 | 44.320706 | 51.745736 | 50.433456 | 40.874609 | 41.360155 | - | 499.227 | |
Act | C | 13.815382 | 15.014906 | 18.960752 | 16.847954 | 17.859494 | 22.402191 | 19.136007 | 15.601053 | 21.030252 | 20.009319 | 18.48511 | - | 199.162 | |
Act | D | 74.929977 | 53.786508 | 69.15376 | 107.4101 | 55.193422 | 70.519295 | 59.561149 | 51.773601 | 66.394184 | 55.585053 | 57.02636 | - | 721.333 | |
Act | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Hi Elke,
Depending on your expressions, you should go to the chart properties, Dimensions tab, and for all dimensions click on the "Suppress When Value Is Null". If that works, that may be caused because your data model has more dates that are not in the chart, but nor properly filtered (i.e: not using set analysis for each year month). That should do.
Hope that helps.
Miguel
Expressions are structured like the following
Sum ({<Year={$(v_Max_NTS_Year)}>}LU)
Elke,
Then the table only has one dimension that is Product? Did you click the Supress When Value Is Null?
Miguel
No it has 2 dimensions. Product and MonthYear.
For MonthYear the options Suppress when value is null and Show all values is on.
For Product not because when selection suppress when value is null dec 2011 disappear.
Hi Elke,
That is the issue. If you want to show at all times all months, even when they don't have sales (because we are in January, and there are still no sales for December) you can use a conditional, so
If(Sum(Field) <> 0, Sum(Field), 0)
It will take longer to display the chart, specially when the data volume is large. But those null values are "normal", that means that, for the selection done in either set analysis or the document, there is no data related (and you are forcing the value to be displayed).
Hope that makes sense.
Miguel