Hi everyone,
I have a Input Schedule where user can add a row to the existing oneu2019s. The account member ID which is added to the existing entry manually should be able to display total of the account memberu2019s Rate X Quantity in the report. I have put Y in the Insert Member of EvDRE expansion on Account dimension and datasource dimension. User chooses the account and manual from datasource. The problem that I face in the report is u2013 datasourcetotal which is the hierarchy in datasource dimension is doing total (datasourcetotal) after every Upload and Manual entry. The reason why I chose datasource to do this task is that there is comment addition in every account row and comment for the manual entry need not be overwritten for the same account, so manual entry will segregate the comment in report display for the same account.
In my datasource dimension it is like this u2013
ID | Hierarchy
Manual | Datasourcetotal
Upload | Datasourcetotal
Datasourcetotal
Before Range and After Range with SUM and SUB functions I believe cannot work in my situation as user can add rows anywhere in the EvDRE layout.
Is there anyway that I can restrict Upload to display total in the report, whereas only total from Manual is displayed.
Also if there is any other way to display dynamic row total in the reports aside from what I have tried above that will be wonderful , my mental faculties are not giving me any creative help, also I have looked around on SDN for anyone else facing the issue u2013 none found.
Any pointers will be highly appreciated.
Regards,
Ben Ramos