Combo chart

[bharatkishore]

Hi All,

I took a combo chart and took dimension as Month and Traffic source.

I have given the expression is =sum(CCF)/sum(TOTAL {<S5_Traffic_Source=>} CCF)

Now the problem is the expression is working fine when i select all the filters.But when i keep the same in chart the values are changing attached images for your reference.

Thanks

Bharat

[sunny_talwar]

I am not sure I understand. Do you want your chart to change based on selection or you don't want it to change?

[bharatkishore]

it should not change Sunny...The value should be 30.91.

please let me know if you need anything more.

[sunny_talwar]

I guess it would be helpful if you can provide a sample as I am still not sure what part of the selection is changing.

[bharatkishore · Accepted solution]

Thanks Sunny for your reply..

I figured it out by giving this expression

=sum(CCF)/sum(TOTAL<S5_Month> CCF)

Thanks a lot...

[sunny_talwar]

But this won't ignore any selection. I thought you wanted to ignore selections

[ThornOfCrowns]

Two things:

1. Your answer doesn't do what your question asked
2. You have marked your own answer as correct - see (1)

[bharatkishore]

May be my explanation is wrong but these are the values what i wanted..

Thanks

Bharat

[bharatkishore]

I m sorry Sunny may be my explanation is wrong..