Missing Dimension

[#1]

I want to populate a dimension even if it's missing in a year.

For example

In 2014 I have six models with sales

But in 2013 I only show 5 models because there are no sales for the sixth group. The users still want to see the group but with 0.

And when I do percentage change from 2014 to 2013 the sixth model is not shown because in 2013 the group is not there.

But instead they want to see 100% increase/change in 2014 since no sales for that model in 2013.

[MK_QSL]

Like  this?

[whiteline]

Hi.

So you have to add these zeros to your data model.

[its_anandrjs]

Use suppress when value null in the chart and uncheck  from the chart properties.

[#5]

You are correct except that the previous year and current year are filter selections.

So Model is a dimension and I am counting sales with expression

=sum( sales) -- for current year

=sum({<season=,season=[Previous]>} sales) -- Previous year

= (sum(sales)- sum({<season=, season=[Previous]>}  sales))/ sum({<season=, season=[Previous]>}  sales) -- Percentage or difference between two years

[#6]

I thought about this but did not try. I can try it and let you know.

[#7]

I tried it does not help.

[MK_QSL]

TRY

ALT((sum(sales)/sum({<season=, season=[Previous]>}  sales))-1,1)

[#9]

use populate missing cells in chart properties