Excluding dimension over expressions

[djallelsadki]

Hi,

If any one can help

I have a combo chart with two dimension ( Time and an another one ) and two expressions

the second expression should only be related to the time dimension but not to the second one

I don't know if i'm clear or not !

Thanks,

D.Sadki

[yduval75]

For example if your second expression is country,

you have to put in your second expression to don't take into account country

Sum({<Country=>} Sales)

[francoiscave]

Hi Djallel,

Can you post an application with some test data and your chart? And if is possible your expected result.

It will be useful to resolve your issue.

Best Regards,

François

[djallelsadki]

Hi,

thanks for your answer, but i tried this and it's not working,

this is my first graph

if i add a second dimension witch contain 3 values, i get this :

what i want is only 3 lines and only one bar on each day

Thanks

D.Sadki

[stigchel]

You can use the TOTAL key word to bypass dimensions so e.g.

Sum(TOTAL <YourDimension> Sales)

[djallelsadki]

not working

thanks

[stigchel]

Did you use the correct dimension within the < >, it should be your first time dimension

Sum(TOTAL <Time> Sales)

[djallelsadki]

yes

i get that

maybe the problem is on the first expression !

thanks,

D.sadki

[djallelsadki]

what i need

n ( number of values in the second dimension) lines for the first expression

and only one bar for the second expression

i will try to post an application...

thanks,

D.Sadki

[djallelsadki]

i post a qvw document

thanks for your help

D.Sadki !