wildmatch and sum

[raadwiptec]

Hi ,

I have a pivot table..

first I need to consolidate all the wild match name to one name

for ex: column name is 'Postion' - data is as below.

moved, transit, moved out,moved in,outin moved, transitout,transitin..etc

so I need to have all the moved in wildmatch and have common name as 'moved'

secondly I have cost for each position for

moved

cost is 100 pounds

moved out

cosit is 150 pounds

etc.

so when making the postion as moved ..I also need the sum of all the cost ..it should be like this

Moved(It includes as moved)

250 (It is sum of cost for all moved)

[Chanty4u]

sum(moved)/sum(total moved)

or

sum(moved)/sum(All moved)

[PrashantSangle]

Hi,

What is your table structure for maintain the cost???

Is it maintain in same table or different table??

For your 1st query try to create new field in script like

if(wildmatch(postion,'*moved*'),'Moved',postion) as newPostion

then use newly created field as dimension and sum(Cost) as expression.

Regards

[raadwiptec]

Hi

First I need to name all the wild matched names to a single name?

for ex: if wildmatch(Position ,'*moved*') ,Postions

here I get all the values in different column.. I need in one column

[jonathandienst]

Could you please supply some more representative data. What dimension/grouping do you need for this analysis?

[Anonymous]

Different Column in Different Tables??

or

Different Column in same table??

Could you share sample data?

[Chanty4u]

If(WildMatch([Position ],'*moved*'), 'moved', 'movedout')

[PrashantSangle]

Hi,

did you try my suggestion???

Try below.

if(wildmatch(postion,'*moved*'),'Moved',postion)

Regards

[raadwiptec]

It is in the same table. I want to consolidate all moved using wildmatch into one single name ' Moved' similarly 'Transit

Add all the cost for moved .I am trying this in an expression

so it should be as below. even country in same table

Its a pivot table

                     Moved ¦ transit

UK                   700        300

Position	Cost
Moved	100
MovedOut	150
MovedIn	200
OutMoved	250
InTransit	100
Outtransit	200

[PrashantSangle]

Hi,

Can you post sample data and your script to load that file...

Regards