Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
On my file sample, I need that making a selection in each list box, the chart that depends on that selection show the selected data compared with the average of the rest.
For example, if in the list box Level1 I select 1000, chart show the level 1000 value and in another column, average sales from level 2000 to 5000.
If in the list box Pto I select adj, chart show the adj value and in another column, average sales from the other values.
I appreciate any help.
Regards
Hi,
generally speaking :
to have exclusion of a selection :
avg( {1<amount = E('Pto') >} amount)
E : to exclude value selected in field
1 : to have all values disregard the current selection
regards
Thanks Olivier for your reply.
I have used your expresion but i must be doing something wrong because the chart shows "no data to display"
Regards
excuse me,
better I think :
avg( {1<Pto = E(Pto) >} amount) /// without quote in E()
Sorry, but show the same result.
Thanks!!