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.
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?
How to sum with group by another column?
-
- Posts: 6197
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to sum with group by another column?
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.
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?
I managed to figure it , you just use the group by header and footer
-
- Posts: 6197
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to sum with group by another column?
Hello,
Thank you for the information.
Thank you for the information.