Forum Discussion

Bhoobala_P's avatar
Bhoobala_P
Frequent Visitor
9 years ago

Use Column Name as Filter

Guys,   I have a dataset like this: Customer ID onsite/offshore Region 01-01-2011 01-02-2011 01-03-2011 01-04-2011 Customer1 onsite    Kuwait 200000 200000 200000 300000 Custo...
Need Help
Bhoobala_P's avatar
Bhoobala_P
Frequent Visitor
9 years ago

Dear Lydia,

 

Thanks for the reply. Let me give some clarity to the picture. This is the sample data:

PracticeEmployeeActivitity01-04-201101-05-201101-06-2011
Project1Employee1Travel500005000050000
Project1Employee2Travel500105001050010
Project1Employee3Travel500205002050020
Project1Employee4Travel500305003050030

 

Pls refer to the snapshots below:

1. Loading the data2. Choosing first row as header3. Result (issue)

Now, how can we make the date appear as such, after making the first row as header in the query editor???

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Bhoobala_P，

What is the data type of Column4, Column5, Column6 in your scecond screenshot?

In your third screenshot, delete the last two steps from "APPLIED STEPS" , then choose first row as header and check the result.

Thanks,
Lydia Zhang

  • Bhoobala_P's avatar
    Bhoobala_P
    Frequent Visitor
    9 years ago

    The data type of these three columns is currency, i.e., they are basically revenues in $. 

    And yes Lydia, I tried deleting the two steps and tried to promote the first rows as headers right of the navigation step (default one).

    Still the same issue..!