Expression total is not working for custom dim and exp

[gauthamchilled]

Hi,

I have a chart with custom dimension and expression. But the expression total is not working at all.

Can you please help why expression total is not working, i dont want to use sum of records

i uploaded a similar example file

Gautham

[Anonymous]

Hi Gautham ,

can you make your question bit clear

[gauthamchilled]

[Anonymous]

Hi

are you  expecting to see totals like  this

[amit_saini]

Hi Gautham,

Like this????

Please check the attachment.

Thanks,

AS

[Anonymous]

Hi Gautham,

Please follow following steps

Properties-->Expression-->Total Mode (click on sum of rows instead of Expression Total)

Please find attached qvw for your reference.

Thanks,

Pooja

[gauthamchilled]

i know some of rows will work...what i want is expression total...

not sure why expression total is not working

[jonathandienst]

Because you are using a synthetic dimension, your expression makes no sense at a total level. Change the total option for the expressions to:

[jonathandienst · Accepted solution]

Better - create a real derived dimension in the load script and you will not need a synthetic dimension.

[gauthamchilled]

Great jontydkpi I thought that would be the issue.

May I know how can i convert the synthetic dimension into real derived dimension?

Do i need to change the expression also?

Thanks

Gautham