"Hi Gary, if I am understanding you correctly, I don't see an automated way to do this, the only thing I would try is copy your static data to the same sheet 1 as the Sales Master report, then modify the RawData named range to include the…"
Hi,I am looking for the best way to add a static sheet that needs to be combined with Sage 300 sales data in the same output data. The static sheet has all the same information as BI sales master report, however, it is coming from another system that can not be connected. I have tried creating additional fields in the pivot table but can not manage to group the fields together. ie customer name or item codes.Any insight on how to accomplish this would be apricated.Thank you.See More
This would most likely be due to User Access Control being active on the machine.
Please have a look at the below links to see the issues that this could cause (yours being one of them):
- Understanding UAC
- UAC in Vista
- UAC in…"