Fetching Not entered values

[yoganantha321]

I have a data like below table: with the master calendars

If I select the

Monday --> EmpId 1 and 3 will be get.

Tuesday --> EmpId  2 and 3 will be get and so on.............

But  I need

On selecting

Monday --> Entered EmpId count=2 and not entered EmpId count=3

Tuesday --> Entered EmpId count=2 and not entered EmpId count=3  and so on...............

Any one can help me in this.......

I cannot attach the sample file along with it. Sorry for the inconvenience.

Regards

Yoganantha Prakash G P

[prieper]

This depends your datamodel,

see the attached with correct calculation

Peter

[johnca]

If your data model is truly a pivot table as presented use the CrossTable function. It will flatten the table out to what Peter suggested above.

temp:

CrossTable(Day,Name,2)

Load * Inline [EmpId, Name, Mon, Tue, Wed, Thu, Fri

  1,A,y,,y,y,

  2,B,,y,,,y

  3,C,y,y,y,y,y

  4,D,,,,,

  5,E,,,y,y,

  ];

HTH,

John