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

[MK_QSL]

Create a Straight Table

Dimension

Month

Expression

1) IF(SubStringCount(Concat(DISTINCT Month, '|'),Month),Only({<Month>}Qnums),0)

2) IF(SubStringCount(Concat(DISTINCT Month, '|'),Month),SUM({<Month>}Sales),0)

Go to Presentation tab and untick Suppress Zero Values

[Anonymous]

Hi

Enable " Suppress When Value is Null " & " Show All Values " under Dimensions Tab.

Remove " Suppress Zero - Values " under Presentation Tab

Hope it Helps!!

[asgardd2]

Hello!

1. Uncheck "Suppress Zero-Values" on Presentation tab:

2. Create expressions :

     For sales:

     Sum({<Month = >} Aggr(Sum(Sales),Month)

     For  Qnums:

     IF(Count(Qnums)=0,0,Qnums)

[Anonymous]

Hi Anton ,

I have a calculated dimension

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))))

I'm not able to incorporate your change in this.

Thanks,

Anupama Jagan

[Anonymous]

Hi Anil,

Im not getting even after doing it

Thanks,

Anupama Jagan

[Anonymous]

Hi Manish

I'm not able to incorporate your logic in my expressions. Can you let me know how to go about it?

I have a calculated dimension

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))))

Thanks for your help

Regards,

Anupama Jagan

[MK_QSL]

Provide sample app here. We will work on it and try to give you solution.

[Anonymous]

Hi Manish,

I dont have any sample app with me as we work in remote desktop.

Maybe i will provide you sample data . will that be okay?

thanks,

Anupama Jagan

[MK_QSL]

OK