non changing dimension

[Anonymous]

Hi all,

Is it possible to make a dimension not changing at all for any filters?

For example I have the following straight table

Month	Qnums	Sales
Jan	Q1234	100
Feb	Q2434	100
Mar	Q234	200
Apr	Q5456	500
May	Q565	300

For this table if for particular selection we have data for only Mar and Apr

So the table will reduce in size showing only Mar and Apr like this

Month	Qnums	Sales
Mar	Q234	200
Apr	Q5456	500

But i want in this manner

Month	Qnums	Sales
Jan	0	0
Feb	0	0
Mar	Q234	200
Apr	Q5456	500
May	0	0

Keeping the month dimension to be constant not changing.

Is it possible?

Any help would be appreciated

Thanks,

Anupama Jagan

[Anonymous]

Hi Vineeth,

Yes I tried. The values are remaining constant for few selections. No change in the table at all.

[tyagishaila]

Try it

Take Month as a dimension with Show All Values.

and create expression for calculated dimension

Hide Month Dimension in presentation Tab.

[Anonymous]

No. It is not showing all months for all selections.

[tyagishaila]

Check attached qvw

[Anonymous]

Hi Anupama,

Find the attachment.

R/murali.

[Anonymous]

Hi Shaila,

The table should show months only once.

Like

Jan

Feb

Mar

Apr

May

And not like

Jan

Jan

Jan

Feb etc

[tyagishaila]

it is because of field Client.

[Anonymous]

No Murali. Still im not getting all months.

[Anonymous]

I tried with your example but when I add that 1 in the set analysis , the values aren't changing at all according to the selections. Any idea why?

[tyagishaila]

Can you share sample qvw for better understanding