3,015
In a report that I've created my column group is the document date. My row group is the sales line item. I am using the saleslineitem view.
I've created a between parameter with the column date.
How it appears on my report is like this, with each document date separated.
I want it to do this, where it aggregates all the dates in one column and sums the amounts.
What expression, or other method, can I implement to make this possible?
*This post is locked for comments
Wonderful! Thank you Adam. That is soooo helpful.
Hi,
In the report designer, at the bottom of the design pane you should see sections for the Row Groups and Column Groups.
If you click on the column group you have and select Group Properties you should then be on the General tab of the properties window.
On the General tab you should see a "Group On" value and this is where you can change it.
Based on what you are looking for I might suggest trying to enter:
=datepart("YYYY",fields!YourDateField.Value) which will group by Year. You could alteratively enter ="1" to just have a single group that summarizes everything.
Let me know if that helps!
Thanks,
Adam
Thank you Adam!
How would I do this? "change the column group to be something at a higer level even ="1" "
Hi,
As you said above, you have the column group set to be your document date so that is why you are getting one column for each date.
What you could do is change the column group to be something at a higer level even ="1" would work in your case since you really are not grouping on anything you just want it all summarized.
Or, if you wanted the column group to be by Year you could parse out the Year from the Document Date and group on that instead.
Then, you can change the label to be an expression that displays the selected Start and End date parameters.
Hope this helps,
Adam
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
