Calculate current month and previous month sales

[Gopi_E]

Hi Qlikers,

@sunny_talwar 

Here I have data like this 

Month_Table:
LOAD * INLINE [
Month_Name, Sales,
Jan, 10
Feb, 20
Mar, 30
Apr, 40
May, 50
Jun, 60
Jul, 70
Aug, 80
Sep, 90
Oct, 100
Nov, 110,
Dec, 120
];

From this table, I need to calculate the current month and previous month sales, please give how to calculate sales using this type of data

Thanks in advance

[Gopi_E]

@sunny_talwar  

Hi sunny can you look on to this 

Thanks in advance

[sunny_talwar]

You want this based on selection or current month will always be Today's month and previous month will be the last month from today. Meaning September will be current month and August will be previous month until we reach October?

[Gopi_E · Accepted solution]

Thank you for the reply,

yes I want this based on the current selection

I did this by creating a table with month name and month number and this table I was joined to the original table.

is there any other way please suggest.

Thanks in advance.

[sunny_talwar]

I am still not 100% sure what you are looking to do... but if you can share what you have applied, I might be able to see what you did and let you know if there are other options you can try