Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 data files Actual, Given.
Actual data file contains Project Num, PName, Pool,Manager, November, December, January fields. Here November, december, january fields contains month wise Demand data
Given Data file contains Project Num, PName, Pool, Manager, Month, Demand Actual, Demand Given. Here Month contains November, December, January as field values.
I want to show by default the data for November, December and January should be as follows
I want to create one List box which contains Months November, December and January. If i click on January then only january should be shown, If i click on November then only November data should be shown.
This is an urgent requirement, Please Anybody take a look and give me solution.
I'm attaching sample data files also, Please provide me solution
You can use the crosstable function to transform the Actual data. See attached qvw
hi have a look at the attach file
all that was needed is to cross table to actual data in the load script
You can use the crosstable function to transform the Actual data. See attached qvw
Hi Bra'am,
Thanks for reply, i met my req with your suggestion.
Thanks,
M V
Hi Wassenaar,
Sorry for troubling you, One more req is added here
I have another file Inc Data which contains Project Number, PName, Pool, Nov Inc/Dec, Dec Inc/Dec, Jan Inc/Dec fields. Based on the Pool and project number i have to add the values of Nov Inc/Dec, Dec Inc/Dec, Jan Inc/Dec to Demand data
For ex:
In demand data file data is like as follows
in Inc Data file the data is like as follows
It should add to Demand of Demand data file, Then the output will be like as follows
If the value is negative the it should subtract, if value is Possitive then it should add to Demand data and it should reflect on Demand and total (in exapmle 9, 7.1) should show in the table.
Please help me on this
i'm attaching Inc Data file also here.
Thanks,
M V
Maybe like attached qvw.