Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart in sense. When i select a specific client, i want to see all months in my bar chart, not only the months where the client bought something. So i should see this
jan : 50
feb : 60
mrt : 0
Apr : 0
May : 10
etc
How can i do this? I have linked a full master Calendar.
I dont want to add 0 values to the fact table, because i have to do this for every possible dimension
any ideas? i tried all check boxes available
Thanks in advanced
Can you tried adding + Avg({1} 0) to your expression? If that doesn't work, would you be able to provide a sample?
That worked Sunny .. briliant.. only one more question.
This give me all years .. i only want to see the current selected year or max year
i dont see where to put this .. something like this :
{<[Year]={$(=Max([Year))}>}
May be this:
+ Avg({1<[Year]={$(=Max([Year]))}>} 0)
Thanks again Sunny!