Hi Powerpivot expert
This forum was of great help to learn powerpivot especially feedback from Ninja Chihiro
am not sure if there is way or workaround to do data write back to Powerpivot table i.e. for unique key after generating report we can added free text and reason code for identified issue.
i have attached excel file which is a simplified version of the data model and what am trying to achieve.
Idea is to use PowerPivot for all the complex calculation that needs to generate a dashboard and KPI reports
Then where KPI is lower then target, user will enter a predefined reason and comment, why KPI was not met the target, however this need to register back to data model table so that further analysis can be build on top of the reason code.
Hope the example helps to put thought
This forum was of great help to learn powerpivot especially feedback from Ninja Chihiro
am not sure if there is way or workaround to do data write back to Powerpivot table i.e. for unique key after generating report we can added free text and reason code for identified issue.
i have attached excel file which is a simplified version of the data model and what am trying to achieve.
Idea is to use PowerPivot for all the complex calculation that needs to generate a dashboard and KPI reports
Then where KPI is lower then target, user will enter a predefined reason and comment, why KPI was not met the target, however this need to register back to data model table so that further analysis can be build on top of the reason code.
Hope the example helps to put thought