Questions EXPORTING TO EXCEL FROM PIVOT TABLE DATA WHICH IS SORTED OUT ON ONE COLUMN

Acumatica Generic Inquiries & Pivot Tables

Last Post by Tim Rodman 7 years ago

2 Posts

2 Users

0 Reactions

2,582 Views

RSS

Posts: 13

Siva Katakam

Topic starter

May 27, 2019 11:29 pm

(@sivakatakam)

Eminent Member

Joined: 6 years ago

Hi tim,

I have sorted out one column in my pivot table which is like descending order. Then when i export to excel the column is going to be un sorted which is not like as i sorted in my pivot table. So how to over come this ?

I want to export the data as it is i sorted in pivot table.

Attached example for sorted data in total column.

Topic Tags

#pivottable #exporttoexcel #sorting #sorting from pivot to ex #sorting in pivot

1 Reply

Posts: 3204

Tim Rodman

Admin

June 4, 2019 10:17 pm

(@timrodman)

Famed Member

Joined: 11 years ago

What version are you on? I just tried on 19.101.0084 and it worked.

Have you thought about just building the Pivot Table in Excel using the OData connection and refreshing from there?

12 Forums
2,533 Topics
11 K Posts
68 Online
2,439 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)