Hi
Attached is a file with the raw data i designed and pivot table is the info i required.
Can someone please advise me which filed should be included in table? Based on employee's request, the repayment amount for the whole instalment can be different for each month and the amount is agreed before inputting.
Hence i am a bit confused which one shall show in table and which one shall treated as calculated field by using query.
Thanks in advance
Attached is a file with the raw data i designed and pivot table is the info i required.
Can someone please advise me which filed should be included in table? Based on employee's request, the repayment amount for the whole instalment can be different for each month and the amount is agreed before inputting.
Hence i am a bit confused which one shall show in table and which one shall treated as calculated field by using query.
Thanks in advance