Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression using a selection and other value

Hello People!

Here is my new problem of the day.

I have an expression that looks somwhow like this:

=sum(value) / sum({<client={"Total"}>} value)

What's happening? My selected value is any client, but when in the Divisor i make like my selection is "Total" it makes the selection for the whole expression ="Total". So in the chart, there never appears the original selected value.

any ideas?

21 Replies
Not applicable
Author

what if you get rid of Month= and year= altogether...  those expressions i think that overwrites the selections that you have already made...

why dont you just to show us some excerpt of how you expect data to behave, the columns that you have etc..

cheers.

JuanD

Not applicable
Author

What i expect:

Market Share TableMS
Harold25%
Arnold24%
John15%
Pete2%

What right now am watching:

Market Share TableMS
66%
Harold
Arnold
John
Pete

I can´t expose my proyect because it has valuable information.