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,218 Views

RSS

Posts: 13

Siva Katakam

Topic starter

May 27, 2019 10: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: 3199

Tim Rodman

Admin

June 4, 2019 9:17 pm

(@timrodman)

Famed Member

Joined: 10 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,527 Topics
10.9 K Posts
15 Online
2,412 Members

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

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

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

Online Members