I am trying to add column names for pivot table via alias but it is taking orgininal field name while exporting to CSV and I have used a table calculation on one field and used the same as well in pivot table. Now, the original field is givng name of calculated field while exporting to CSV.
Eg
Orginial Field- Proceeds and Table Calculated Field: Rank
while exporting I am getting header as two Rank fields. Kindly help.
Hello @AlishaS1234, maybe I am misunderstanding the issue, but I just tested this locally and it worked fine for me. I created a pivot table with a few values, and I added a field called Profit twice. Once to show it as a sum and then another that I used for a running sum table calculation. I updated the header name for the field that is used as a table calculation to Running Sum instead of Profit and it showed with the correct name in the CSV I downloaded.
I’ll include some screenshots below to show you what I did. Does this resolve the issue you are facing?
This last screenshot is from the CSV I downloaded:
Let me know if I am missing something here and I can help guide you further. Thank you!