• For Pivots, why is the grouping and data staggered?

    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…
  • Add pivot values together

    I have a pivot of WIP status and the values I see are firm and suggested. How can I add the two pivot columns for planned qty to get a total firm + suggested?