Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I am trying for customized report, its not working.
Please look into it and help
PFA
Script:-
DimensionList:
LOAD * INLINE
[
dimension_1,dimesnion_flag
Name,1
Country,2
Job,3
];
LOAD * INLINE [
Parameter_1, Parameter_flag
Salary, A
Taxes, B
];
Data:
LOAD * INLINE
[
Name,Country,Job,Salary,Taxes
Philip Lawrence,USA,Teacher,35000,2000
John Schummacher,Germany,IT Consultant,42000,3500
Albert Casanella,Spain,Salesman,52000,5000
Alexander Xiao,Hongkong,Doctor,48000,4400
Ayax Smart,England,IT CEO,80000,7000
];
Yes that's the intention. To select the dimensions of the table builder from 2 list boxes.
Now it is not possible to select different dimensions in the different list boxes.
Br,
Try this with two different inline loads
LET HidePrefix = '%';
Fieldlist1:
LOAD * INLINE [
%Field,%Field_Explanation
Surname, First Name salesman
Name, Second Name salesman
Country, Country salesman
TotalSold, Total amount of Sales
];
Fieldlist2:
LOAD * INLINE [
%DateFields, %Date_Explanation
Birth date, birth date salesman
DateFirst, Date first Sale
DateLast, Date last Sale
];
Data:
LOAD * INLINE
[
Surname,Name,Country,Birth date,TotalSold,DateFirst,DateLast
Mark, Lawrence,USA, 03-03-1965, 35000, 02-02-2016, 15-10-2016
Kevin, Schummacher,Germany,12-02-1985 ,42000, 05-10-2010, 15-10-2016
Bert, Cast,Spain,23-03-1970,52000, 02-11-2005, 15-11-2016
Alex, Ho,Hongkong,14-06-1975,48000, 22-03-2012, 05-10-2016
Max, Best,England,20-09-1980,80000, 06-08-2014, 15-08-2016
];
So now you can see that you can select in both the list boxes at the same time. In addition, current selection is not showing those selections because of my use of HidePrefix (Read about HidePrefix – hiding fields here).
HTH
Best,
Sunny