14 Replies Latest reply: Jun 22, 2012 1:55 AM by Florian Kratzer RSS

    Show dimension when there is no data

      Hi all,

       

      let's say i have a pivot-table with the dimensions year and month and an expression which calculates the revenue.

      Now i wanted to show the dimension 'month' even when there is no data. BUT it should stay filterable. So the 'Show all values'-Option is not an option for me.

       

      So i wanted to display it like this:

      Year     Month     Revenue

      2012     01          100

      2012     02          150

      2012     03          0               //show dimension even when there is no data

      2012     04          350

      ...

       

      And when i e.g. filter month = 04 then the result should look like this:

      Year     Month     Revenue

      2012     04          350

       

      and NOT LIKE this (same filter)

      Year     Month     Revenue

      2012     04          350

      2012     01          0

      2012     02          0

      2012     03          0

       

      Hope you get what i mean.

       

      Is that even possible?

      I've previously searched for a solution on the internet (inclusive forum) but without any success.

       

      Thanks in advance.