How to avoid duplicates when export to excel?

[#1]

Hi,

I have one table which have dimension CustomerID with duplicates. for each CustomerID there are multiple unique ID. My user don't want to see duplicates in CustomerID when exported to excel. but wants all CustomerID with ID. so, I used Pivot table. In qvw it is showing only once instance of CustomerID with ID, but when exporting to excel it is showing duplicate CustomerID.

How to sort this out. Can anyone help me please.

Thanks.

[ashfaq_haseeb]

Hi,

have a look at attached application and Export.

Let me know if that worked.

Regards

ASHFAQ

[martynlloyd]

Did you use DISTINCT or GROUP to create a summarized table?

This should definitely work. Can you describe your data?

Marty.

[#4]

Thanks very much. will the macro work if I use this macro in qvw which is in access point? because I have not used any macros in my qvws which are in access point?

[ashfaq_haseeb]

Hi,

Yes you have to use IE Pluggin.

Macros will not work on AJAX Client.

If it answered, can you close this thread.

Regards

ASHFAQ

[#6]

Thanks. unfortunately we have Ajax client. how can I solve this with Ajax client. Is there any other way?

[ashfaq_haseeb]

Hi, Macros does not work with Ajax.

I don't think there is an alternate.

Regards

ASHFAQ

[martynlloyd]

Going back to your pivot chart, please can you post the expressions here?

[#9]

Thanks. All I have the expression as below

=If(colour<>'out',colour)

=Count(distinct(If(IsNull(Dateproblemresolved),ID)))

CustomerID is used as dimension

[martynlloyd]

Ok. Now how is the user exporting to excel,

Is he/she using Export...

Or is he/she using Send to Excel?

[#11]

Thanks. User is using send to excel. Please any help.