Input data in a module published in a dashboard
I created a module with subset list as row and column line item named as assumption methods.
Row Subset list are expense accounts while column line item are assumption methods e.g average YTD actual periods data , escalate YTD actual periods data or Input fixed amount
I would like my module when published to dashboard to list down all expenses as rows and on the column for each expense will have drop down list which will show the 3 assumption methods. User will select what assumption method to use for each expense.
Then on the 2nd column i would like to reflect the Base amount for average or escalation methods which will pull data from an existing module and 3rd column will be input of fixed amount if that was chosen as method.
Another way is to reflect all assumption methods as columns 1 to 3 then theres checkbox which can be ticked if it will be chosen and it is not allowed to tick more than 1 box.
How can i do this? Thanks.