use original field

[everest226]

HI ,

Bellow is the sample , i am trying to create two separate chart , is it possible to use  field from table that has been drop , in one chart and field from resident table in another chart .

so basically i want to use field Cat  in one chart and Zone in another chart.   this is just a logic or any work around

[sunny_talwar]

Cat and Zone are one of the same thing... but Cat is dropped... how would you use Cat as a dimension when it isn't even present in the your application? What exactly are you trying to do?

[everest226]

AB:

Load

[Channel Code],

    Counter,

    [ Agency Code],

    [Agent Name],

    [Payment],

from <<<<<<<

[Final AB]:

Load

Load

[Channel Code],

    Counter,

    [ Agency Code],

    [Agent Name],

   [Payment] -  Previous([ Payment])  as  orginal _Payment, 

Resident Group

Order by [ Number],QVDYear,QVDWeek,[Tr Booking Date];

     Drop Table Group;

So basically one chart that are built are using all the calculated group by field from residence table . the requirement is to build another chart but without all the group by calculation . basically from original AB table . hope i am clear

[sunny_talwar]

I don't see any group by? I see Order by... but what are you grouping here or intending to group here?

[everest226]

I mean order by

[sunny_talwar]

So you want to have payment and original_payment?, then why do you not bring payment in the final table?

AB:

Load

[Channel Code],

    Counter,

    [ Agency Code],

    [Agent Name],

    [Payment],

from <<<<<<<

[Final AB]:

Load

[Channel Code],

    Counter,

    [ Agency Code],

    [Agent Name],

   [Payment],

   [Payment] -  Previous([ Payment])  as  orginal _Payment,

Resident Group

Order by [ Number],QVDYear,QVDWeek,[Tr Booking Date];

     Drop Table Group;

[everest226]

So its order by QVD week and Year, ,  and i have use those field on chart , what if i dont want to  use order by data  and only want to use original table data in new chart in same application

[everest226]

ok i understand now

[sunny_talwar · Accepted solution]

But order by is doing nothing to your original data... you can still use it without any issues

[everest226]

Thanks For your help