We have created a report which will show the previous day values in the report. For example, when we select 10th July 2016 report then it will display the 9th July data and Opening balance will be calculated till 8th July. And Closing Balance value will be the sum of Credit, Debit and Opening Balance. Please refer the attached Screen1.JPEG. We have four expressions: Credit, Debit, Opening Balance and Closing Balance
But we need table format in our dashboard as Screen2.JPEG, could you please help me to achieve the format as Screen2.JPEG.