x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 41 subscribers
  • Views 1888 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
Lee Sommerfeldt

For Pivots, why is the grouping and data staggered?

SOLVED
Posted By

I'm trying to automate reporting for my organization. However when utilizing SEI's pivot function, it staggers the groups from the data itself making the data useless upon exporting to Excel. I'm hoping there's some setting where I can have a more traditional pivot layout appear in SEI.

Thank you in advance for any help. 

Parents
  • +1
    verified answer

    Hi Lee:

    That is the way a pivot worksheet functions using the SEI web client.  You can expand and collapse the grouping levels to see the details.  I would suggest you use the SEI Excel add-in and you can create the pivot table directly from Excel without using the web client and exporting.

Reply
  • +1
    verified answer

    Hi Lee:

    That is the way a pivot worksheet functions using the SEI web client.  You can expand and collapse the grouping levels to see the details.  I would suggest you use the SEI Excel add-in and you can create the pivot table directly from Excel without using the web client and exporting.

Children

*Community Hub is the new name for Sage City