No automatic separation of totals on key field (e.g. currency, UoM) when using bind_alv

[mahlzeit1948]

Hello, we would like to use the bind_alv method to create Excel files. It works well but we noticed that the automatic separation based on key fields is not working.

Example:
currency amount
USD 1000
USD 4000
CAD 2000

in ALV the system will automatically split the totals line into two (one for USD and one for CAD). With bind_alv the generated file will just contain a SUM formula on the whole amount column and display 7000.

[sandraros]

Thank you for raising the issue. I think I understand what you say, but just to be sure, could you add a screenshot for totals in the ALV and in the generated Excel file please? Thank you.
Also, do you think of a formula in Excel which can do the sum for each currency code? (to keep the idea of a formula so that to keep the same kind of logic as currently, but of course if no formula is possible, maybe we'll need to switch to hardcoded sum values)

[mahlzeit1948]

The expected result could be achieved by using SUMIFS Excel formula, but ABAP2XLSX would have to analyze the different combinations of key fields of all aggregated columns and then add a line per combination and construct the formula accordingly.

Here is an example of two key columns and their permutations: