Hello,
I am trying to create a infopath form to capture data for various metrics for a financial dashboard. Issue I am facing is each metrics have 3 measures Actual, Plan , Target. Normally in infopath each field can capture only one value (bound).
Challenge is to create a field that can capture 3 measures for each metrics in a sharepoint list.Second issue is I want to export the data to excel, where metrics are populated as rows and the above mentioned measures as columns for each month.
I need to capture this for each month in a sharepoint list. Please can anyone provide any ideas or suggestions as how to go about building the form and list to capture the data in the above layout/format.
Thanks in advance for all your help