Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QV users:
I would like to request your help on the attached QVW sample,
I am trying to compare combined May & Jun sales in 2014 ($100+200 = $300)
with individual Jan & Feb sales in 2015 $300 & $ 400
in the attached sample QVW I am looking to create a column like this:
I have created alternate states C & P for Current Year/Month & for Prior Year/Month respectively.
Any help would be greatly appreciated.
Kumar
Ok, I've added the missing records in the INLINE LOAD.
Kumar,
maybe like attached?
Hello Swuehl;
Many thanks for your reply and for your time, your solution was good, but when I applied to my main model I had an issue since I forgot in my sample to add product as a dimension. Would it be possible to relook into the sample for a desired result like following
That's not trivial.
I do have a solution, but it fails for the Prd where you don't have any records in State C.
Prd B will just not show up.
I assume this is also the case in your real data, or do you have data for each Prd (could be zero value)?
Hello Swuehl;
The data structure for actual purpose has values in both the states P & C , my example was again bad,
there will not be a case like Prd B
Sorry for the inconvenience,
Kumar
Ok, I've added the missing records in the INLINE LOAD.
thanks very much Swuhel, appreciate the help