Pls Help

[antonybi]

Hi,

Am trying to get below output with my actual data.

I have some sample data(Main/NoShow) in two sheets and looking for below desired output.

I have tried with apply map and lookup but not getting what exactly looking for.

Any suggestions will be appreciated.

Kindly help!!!

[Anil_Babu_Samineni]

May be attached?

[Anil_Babu_Samineni]

To get correct format use this?

Date(MonYr,'MMM-YY') as MonYr,

[antonybi]

Hey Anil thanks for your quick suggestion.

am unable to open your attached as am using only personal edition.

Can you paste your script here??

Also find attached sample one and correct If am anything wrong.

[its_anandrjs]

You have to load this way

Script:-

LOAD Date(MonYr,'MMM-YY') AS MonYr,

     Emp,

     Dept,'EmpNonshow' as TabFlag

FROM

NoShow.xlsx

(ooxml, embedded labels, table is Main);

Concatenate

LOAD Date(MonYr,'MMM-YY') AS MonYr,

     Emp,

     process,'Noshow' as TabFlag

FROM

NoShow.xlsx

(ooxml, embedded labels, table is NoShow);

Chart Expression:-

Dim:- MonYr

Expre TOTAL HC:- =Count ( {<TabFlag={'EmpNonshow'}>} Emp)

Expre Noshow Emp :- =Count ( {<TabFlag={'Noshow'}>} Emp)

Expre Non Noshow Emp :- =Column(1)-Column(2)