any body please look into this, Question is at discussion

[#1]

Hello every one,

Here is my scenario:

i have revenue, and store.

I need to create two buttons showing the count of the stores one is highest revenue (here i apply some condition like > 100$) and second one is lowest revenue.

if you click on the highest revenue button the beside table should show the store and revenue details  (only for the highest revenue ).

The action same for the lowest revenue too.

Please help in this.

Thanks in advance

[whiteline]

Hi.

If you strongly want to use buttons, you can create all needed charts separately and then add show condition with variable. Then add buttons with actions to switch the variable value and therefore the charts to show.

[Anonymous]

Hi,

use a straight table, use count(store) as exp.

use select in field in the button

now type in the name of the field and use max(total revenue) as exp for maximum

|||ly
min(total revenue) as exp for minimum

HTH

ravi N.

[vardhancse]

Try to alternate state for button and corresponding table.

So only that table will be changed for the button action.

[#5]

Create two tables separately for highest and Lowest revenue.

Create two variables.

In Buttons Add action using the variable to show the specific tables