Page 1 of 1

How to sum with group by another column?

Posted: Wed Dec 15, 2021 5:15 pm
by kryton
I have a sum on two columns T/O PTD and T/O YTD that works ok, but I want the sum to be by currency.
Image
Image

I want to use the distinct currency values from the Currency column to group the sum on T/O PTD and T/O YTD.

Is that possible?

Re: How to sum with group by another column?

Posted: Wed Dec 15, 2021 11:37 pm
by Lech Kulikowski
Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?
Also, please send us your report with test data for analysis.

Thank you.

Re: How to sum with group by another column?

Posted: Thu Dec 16, 2021 10:17 am
by kryton
I managed to figure it , you just use the group by header and footer

Re: How to sum with group by another column?

Posted: Sat Dec 18, 2021 9:39 am
by Lech Kulikowski
Hello,

Thank you for the information.