That is a way better approach! Thanks!

Thanks a lot Luis!

I understand your code and it works perfectly!

.... What can I say? I have read it 10 times now and it sounds like THE MASTER is severely correcting one of his students.

Thanks for your reply anyhow! I...

I have added CREATE and INSERT queries!

Could you explain what you had in mind with the MOD function?

Thx!

Hi Sean,

Thanks for your reply.

I have attached two screenshots with extra info in my reply with the SQL code.

Hopefully I managed to get my point clear enough.

regards,

Michiel

Unfortunately I am not able to attach the 2 images properly in my reply ...

I used the image shortcut with an absolute URL to my local system using syntax "file:///C|/dir1/dir2/filename.png".

No...

Okay, I have prepared some code:

Create table:

/****** Object: Table [dbo].[_FinancialReportingTEST] Script Date: 5-7-2014 10:36:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[_FinancialReportingTEST](

[ID] [int] IDENTITY(1,1) NOT NULL,

[GeneralLedgerAccount] [nchar](9)...

Thanks Varsha, I did it exactly as you mentioned!

Hi,

Maybe I was a little bit vague, but my point was not about the parameters that you have to fill in before you hit the button View Report.

I wanted to...

Hello Koen,

Could you be more specific? I am not sure what you mean ...

Thanks!

My source is not a SSAS cube. Just a table.

I will try to explain and will only stick to the relevant tables and fields.

In my DSV fact-table I have got a transaction date, itemcode and a sales amount.

In my...

Thanks! That was the trick!

Answers are very simple, sometimes!

Thanks for your reply!

I do something wrong but not sure what ...

I think the @SumColumns variable is not correct.

Hope you can help me out? Thanks

Here is my query:

DECLARE @Columns VARCHAR(MAX)

DECLARE...

Thanks a lot, but this adds a total row to the pivot.

What I would like to have is a total column at the end of the row that contains the...