Hi @PowerAddict and other experts,
I have done a collection using the following formula and it looks ok
ClearCollect(SalesbyLocation,ShowColumns(SalesTable,"SalesYear","SalesMonth","Customer_x0020_Name_x003a_Root_x","Total_x0020_Invoice_x0020_Value"));
Following is how it looks like, the Root comes as a group with ID and Value.
Following are my requirements,
1. How can I get the Customer Name root..... with value only to my current collection
2. How can I create a collection to show the Total Invoice Value by Location (total must be summarized by location)
Thank you
Osmand
Solved! Go to Solution.
Thank you @PowerAddict your direction is helping me lot.
I was able to find an answer to the 2nd question by my own, i applied the following and it worked
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
169 | |
94 | |
64 | |
64 | |
60 |
User | Count |
---|---|
241 | |
163 | |
95 | |
85 | |
82 |