Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have month column , and 2 additional columns Value 1 and value 2
Jan Feb Mar so on,,,,, Dec
Value 1 Value 2 Value 1 Value 2 Value 1 Value 2
200 132 220 125 125 265
My requirement as below
If it is January then Value 1 of January + Value 2 for the rest of months until december(Feb+Mar+Apr+ .,...Dec)
If it is Febrauray then Value 1 of January and Februalry + Value 2 of Mar +apr + may +.......Dec
If it is March then Value 1 of (Jan+Feb+Mar) + Value 2 of ( Apr+ May + Jun +..... Dec)
any suggestions? here
br
raadi
Would you be able to provide a Excel based sample with more data points and the expected output here?
Hi sunny,
the sample file looks like this.. i already found a solution but interested to know what are the other ways...
This sample looks slightly different then what you asked above. I don't see Feb, Mar....? What is the expected output for the sample you have provided?
Hi sunny
already this data is loaded.. into QVD. From there on I need the solution similiar as below
Value 1 and value 2 corresponds to the Estimate and definite
an Feb Mar so on,,,,, Dec
Value 1 Value 2 Value 1 Value 2 Value 1 Value 2
200 132 220 125 125 265
My requirement as below
If it is January then Value 1 of January + Value 2 for the rest of months until december(Feb+Mar+Apr+ .,...Dec)
If it is Febrauray then Value 1 of January and Februalry + Value 2 of Mar +apr + may +.......Dec
If it is March then Value 1 of (Jan+Feb+Mar) + Value 2 of ( Apr+ May + Jun +..... Dec)