Buttons reflect sheet objects dynamically

[nareshthavidishetty]

Hi,

We are having 3 fileds namely Supplier,Country and Customer and we have few charts in sheet.

The user needs 3 buttons namely Supplier,Country and Customer.

Here If the user clicks on supplier the whole data in the sheet should aggregate by supplier accordingly.

Thanks..

[sasikanth]

HI Naresh,

It always depends on the display of data i.e. granularity of your data.

please do elaborate your requirement.

[shiveshsingh]

If Supplier,Country and Customer are dimensions?

You can use adhoc reports concept to get your goal.

[Ben_P]

The easiest way to do this is to create a cyclic group for those dimensions, so that the user can switch between them at will.

Settings>Document Properties>Groups>New>Cyclic Group ... and add your dimensions to the group.

You can then use this cyclic group as the dimension in your charts and tables.