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]

And I have doubt regarding the cumulative sum. Im using a cumulative sum to show for all the selections. So technically if there is no data for a month it should be populated from the previous month right? ideally no zeros should come inbetween right..

[Anonymous]

The problem is I work in a remote desktop I cant share any QV app over here

[Anonymous · Accepted solution]

Hi All,

I solved it by adding another expression sum({1} Revenue)

Thank you all for your help