Export Excel from Pie Chart

[balanandam]

Hi,

I wanted to understand is there any way to do this ? I want to display only top 5 counts in Pie chart by default, But I exports into excel, then excel must contain all the info. is this possible ?

Thanks!

Balanandam

[marcus_sommer]

It's not directly possible. You will need either two objects or at least a switch maybe with variable to the TOP n value or a dimension-group with the TOP and all values.

- Marcus

[avinashelite]

Yes , agreed . Other way would be is to add a macro to achieve this and for excel export you need to trigger the macro via button/text object