Savings calculation

[kkkumar82]

Hi Qlikers,

I have some data in the below format

ProjectID	Org	StartMonth	EndMonth	Month1 Savings	Month2 savings	Month3 Savings	......	Month12 Savings

Based on the start month column and End month column will be having savings but the start month and end months for all the projects

may not be the same,

I want to have a table which can show me data like below

Project ID , ORG, OCT,NOV,DEC,JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP

Note: For all projects it is not mandatory that they should have all months data, attaching a sample spread sheet.

[sunny_talwar]

This?

[kkkumar82]

Give me a minute, I will check, meanwhile I think the data in the sample excel is also not correct, sorry for that

[kkkumar82]

The table is close but, irrespective of the years can we get the data under the same months, I mean, oct 2016 or oct 2017 should come under oct, as we have in data model a calendar filters , we can filter out them by Fiscal Year and Fiscal Month

[sunny_talwar]

Change the MonthYear field with the Month field I have in the application

[kkkumar82]

This can really help me thanks for the immediate jump, I need to play on this , as the original data is in fiscal and I also see some discrepancy in the data

Thanks much Sunny