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]

I have now attached a sample data. It has year,month,revenue and client fields. so if we select any clicnet the month has to show always till current month.

the dimension and the expressions used in the application is given above.

Thanks,

Anupama Jagan

[MK_QSL]

Something like this..

[vinieme12]

use the below

CYTD:

if(Month <= Month(today()), rangesum(above(total sum({1<Year = {$(=Max(Year))}, Met = {"Approved"}>}Revenue), 0, RowNo(TOTAL))))

PYTD

if(Month <= Month(today()), rangesum(above(total sum({1<Year = {$(=Max(Year)-1)}, Met = {"Approved"}>}Revenue), 0, RowNo(TOTAL))))

[Anonymous]

Hi Manish,

I find all the previous year revenue to be zero. May I know what have you done in this?

Thanks,

Anupama Jagan

[Anonymous]

Hi Vineeth

But the values will not change for any filters right?

Thanks,

Anupama Jagan

[tyagishaila]

For Month Dimension

Check Show All Values

[Anonymous]

Hi Shaila,

For me that option isn't enabled at all..is it becauseI have used a calculated dimension?

[tyagishaila]

what output you required?

[Anonymous]

Hi Shaila,

These are my Dimensions and Expressions:

Month

if(Month <= Month(today()),Month)

Expressions are :

CYTD:

if(Month <= Month(today()), rangesum(above(total sum({Year = {$(=Max(Year))}, Met = {"Approved"}>}Revenue), 0, RowNo(TOTAL))))

PYTD

if(Month <= Month(today()), rangesum(above(total sum({Year = {$(=Max(Year)-1)}, Met = {"Approved"}>}Revenue), 0, RowNo(TOTAL))))

So as per my calculated dimesion the straight table will display only till current month ..So Jan- May will be displayed.

But for few selections there might be entry for few months. For example for a particular selection feb month values might not be there. So in the table we will have Jan,Mar,Apr and May be displayed.

But I want Feb to be displayed as well. Kindly let me know if stil requirement is unclear

Any help would be appreciated

[vinieme12]

have you tried yet? please try and let us know