Hi Thiru,
You're not able to Drill to transaction because the SUM formulas point to a module that is different from the module containing the main data
In your screenshot the Amount line item which is being summed up is coming from a module called "Actual Amount Spent Actual Amount Spent Transaction Data". For the drill to transaction to work, the SUM properties must also come from the same module. So the formula has to be:
Actual Amount Spent Actual Amount Spent Transaction Data.Amount[SUM: Actual Amount Spent Actual Amount Spent Transaction Data.Date, SUM: Actual Amount Spent Actual Amount Spent Transaction Data.Expense Type].
But before you apply this formula, you have to get the "Date" and "Expense Type" line items into the module "Actual Amount Spent Actual Amount Spent Transaction Data"
Let me know if you need more help
Regards,
Anirudh