Question on list box

[ramanarayan]

Hi Experts,

I have a list box with a list of customer names. I have 3 problems related to this.

1) When i try to export the list of customer names into excel i do not get the header in the excel.

2) When i apply some filter and then export to excel, i do not get the list of customers with the current filter selection made but all customers. However, the excluded customers appear in grey which i do not want it to be.

3) When i apply some filters with the 'hide excluded' property checked, the list of customers that are pertaining to the filter selection i make do not appear one below the other but instead i see blank rows in middle of the list box.

If you could please help, would be appreciated.

[OmarBenSalem · Accepted solution]

instead of having as a filterBox = YourDimension

Try to alter it as :

=aggr(Only({$<YourDimension= p({1})>} YourDimension ),YourDimension)

when you do some selection, you will find only the associated values appareaing in your filter; then try to export it

[ramanarayan]

Perfect!!.. One more requirement.. Is it possible for the Title to be seen while exporting to excel ??

[OmarBenSalem]

No idea !

I think you should see with macros ; I don't think it can be done natively

[ramanarayan]

Ok Gr8 thanks for ur Help!!