Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
What i expect:
Market Share Table | MS |
Harold | 25% |
Arnold | 24% |
John | 15% |
Pete | 2% |
What right now am watching:
Market Share Table | MS |
66% | |
Harold | |
Arnold | |
John | |
Pete |
I can´t expose my proyect because it has valuable information.