Hi Jeff Moden.

I face some problems while building the cube. Need your help to finish the project. Can we sum total seconds by day, and do splitting by day if...

Thank you very much :-):-)

That's exactly what I'm looking for. Think, the rest I can get in Analysis Services.

Thank you so much...

Here are rules for calculation:

1.If person come in and go out one time: Calculate time duration in the office.

2.If person come in and go out multiple time: Calculate summery of...

Hi again, here is a code for my Data

--===== Create the test table with

CREATE TABLE [dbo].[Data 00](

[Transaction date] [nvarchar](50) NULL,

[Transaction Time] [nvarchar](50) NULL,

[Transactin Code] [nvarchar](50) NULL,

[Transaction Description] [nvarchar](50) NULL,

[Staff...