Data BAse Format in QV

[abhaysingh]

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

[anbu1984]

How do you calculate Mar and Apr target?

Mar = Jan + Feb ?

Apr = Jan + Mar ?

[abhaysingh]

no anbu...i am getting in the similar fashion for rest of the month are these are fixed value

[buzzy996]

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

[anbu1984]

Check Crosstable

[abhaysingh]

how can i do it with cross table pls give me some examples or process to do it

[anbu1984]

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;