Customized Report

[#1]

Hi Folks,

I am trying for customized report, its not working.

Please look into it and help

PFA

sub2u444‌

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

];

[#2]

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,

[sunny_talwar]

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