I did work on .net but new to AX, I want to make a view for Shop wise daily sales columns are:
Shop ID => Parameter Field
Date (column 1) || Gross Amount (Column 2) || Discount (Column 3) || Net Amount (Column 4)
The problem is, I cannot get sum function direct with view (in ax), so I created a query but when I use this query with my view it is not providing me fields which are sum fields.
Anybody have an idea how to do that?
*This post is locked for comments
have a look at msdn.microsoft.com/.../bb314551.aspx and search for 'aggregate', it should give you an idea on how to add (for example) a sum to a view
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
shanawaz davood basha
6
Share
Report
All responses (
Answers (
