Comparing 2 months data in a table

[Anonymous]

Hi, I need help in creating a Pivot or Straight Table with following kind of Data. Its mainly comparing 2 months data. In the below example I have data for 2 months Jan and Feb for a perticular Group and sub group, which shows a movevent (Positive or Negative) for each month. Now I need to show all the data which has a negative movement in the month of Feb (Row 11 and 15). Along with that I need to show the movement of the same in its previous month i.e: JAN. Either in a table or in Pvt Table. Please help me resolving as I am not able to put 2 months data in the Pvt Table.

 

[v_iyyappan]

Hi,

    You use Set Analysis Expression ' Count( {$<Movement = {Negative}>} 1) '. You will get the MonthWise Negative

Movement .

    Hope its useful for u .

Regards,

Iyyappan.

[kaushiknsolanki]

Hi,

     Have a look at the attached application.

Regards,

Kaushik Solanki