Row deletion and display in new chart

[#1]

I have a chart that calculates some values on the fly based on user input for number of months (see attached).

I need to select the values for the last month and display them in the format below in a new chart (Table B). I can't seem to find an easy way to do this via Qlikview. I am able to create a new table and capture desired values through a macro, but cannot populate the newly created table with these values.

Any help will be highly appreciated.

[Miguel_Angel_Baeyens]

Hi,

This issue is very similar to the one discussed in this thread. Please check it and change the code to fit your field names and expressions.

Hope that helps.

Miguel

[#3]

Thanks for your prompt response Miguel. I will try out your solution and let you know how it went.