Designer 2.0 Pivot Total - Possible to Move location?

Hello. I have a report where the user/consumer would like the "Total" column I have in the Pivot moved in front of the other Measures. Is that possible? I don't think that is possible in Excel and haven't figured out how to do in Birst, or attempted to do expressions to accomplish the pivot, rather than the built-in functionality. Thank you.

Find more posts tagged with

Birst - General Discussions

Comments

Legacy Contributor

Short of a solution in Pivot table functionality, I created individual AR buckets and created a Total column that I could put first. More work but got the job done.

Legacy Contributor

As usual, solving one problem creates at least one more! I'm getting multiple records now, in this case for each customer which appears to be driven by the use of multiple expressions for each AR aging bucket. So my Current is on one row, and then 1-30 is on next row, etc. Didn't expect this, and verified that there was not an extraneous data column causing the row breaks, like a sql query issue can cause. Trying to look at community and campus for ideas, like maybe grouping.

Legacy Contributor

Achieved the desired result by not only going away from pivot to individual bucket expressions, but had to go with WHERE statements and doing away with IIF. Go figure.

Copyright © 2025 Infor. All rights reserved.