Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
business | jan 14 | feb 14 | March 14 | Apr 14 |
---|---|---|---|---|
target | 10 | 20 | 30 | 40 |
actual value | 8 | 18 | 28 | 38 |
i have a data source in this format for different different business but i need this data in below format
Business | month | target | actual value |
---|---|---|---|
xyz | jan 14 | 10 | 8 |
xyz | feb 14 | 20 | 18 |
is this possible in QV after doing transformation becasue i have so many data in excel format would not possible to define it manually in excel.. kindly suggest
thanks in advance
How do you calculate Mar and Apr target?
Mar = Jan + Feb ?
Apr = Jan + Mar ?
no anbu...i am getting in the similar fashion for rest of the month are these are fixed value
u simply load ur data into pivot table and try to ply with rows & cloumns by moving top to left and left rows a top columns
Check Crosstable
how can i do it with cross table pls give me some examples or process to do it
Initial:
CrossTable(Month,Value)
Load * Inline [
Business,Jan14,Feb14,Mar14,Apr14
actual,8,18,28,38
target,10,20,30,40 ];
Final:
Load Month,Value As Actual Resident Initial Where Business = 'actual';
Join(Final)
Load Month,Value As Target Resident Initial Where Business = 'target';
Drop Table Initial;