Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
6 years ago
Solved

To display without aggregation in matrix

Hi all i have two tables one has 72000 rows(Date from 01-MAR-2017 to 01-MAR-2019) its Month On Month Data. Table2 has output from software data which just has 24 months(MoM) data and has only two columns date & output. 

Now using matrix i have used table 1 to aggregate all profit and losses for mom.

I need a final output in a matrix as Difference, that will be profit and loss from Table 1 and Output from table 2. I have attached the images.

Eg: (Table 1) April 2017 Profit and loss is -2,59,91,854 and (Table 2) 01 April 2017 As per tally is -1,089,731 i need output as

Difference in the last row of matrix as -2,49,02,123.