on 02-14-2017 9:45 PM
Hello IBP Guru's,
We have 2 requirements for Excel Addin local members:
1. We have Sales Fcst Qty being displayed at Customer Group + Sales Rep + Product ID + Customer ID. One Product is being sold to multiple Customers. So we need to insert a sum total local member in Excel UI at Product ID for all the Customers. Is there a Group By function that we can use for local member and show the sum total @ ProductID for all customers and also show the individual customer fcst qty?
For e.g. In the below screenshot, we want to show the sum total for Product ID = 1001620, for all customers
2. We also want to show the sum total @ each Quarter and Year-To-date columns, where in the month totals are consolidated into Quarter and Year, based on time profile ID.
Appreciate if anyone can provide some insights.
Thanks,
Mangesh
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.