What? I don't understand your question.

You've been here way too long to post questions like you do. No data, no table structures, nothing. As such, all I can do...

CREATE TABLE scripts? INSERT scripts with dummy data? Lots easier to sort out with at least something to work with. Without that I can only hazard a guess.......

Kevin,

Does your computer automatically play Pink Floyd whenever you're forced to work on it...? The till working in the background might be good incentive...

You can insert a row below the matrix outside the group and put the total there, and it will only show on the last page.

Right-click on the matrix/tablix, and in...

You're describing a matrix. You can add a totals column if you wish as part of the matrix.

I agree, but then it's not my homework. If you want good help, provide create table scripts etc.

Sorry, the more I read this, the more odd it sounds. Are you stuck with this table design? It just sounds a little off. I'm not sure i...

You may need to use SUMMARIZE. Think of it like the DAX equivalent of a summary query in T-SQL... Complete with GROUP BY etc.

Here it is from the MS...

In that case, you would...

I would do this with a (deliberate) cartesian product between Calendar and ParkingSpaces...

SELECT p.ParkingSpace, c.CalendarDate

FROM ParkingSpaces p CROSS JOIN Calendar c

WHERE c.CalendarDate BETWEEN '01-Jan-2016' AND '31-Dec-2016';

then just insert that result...

See if Alan Burstein or Eirikur Eiriksson will bite... might be Monday though.

I have a reasonable idea of what you're trying to do... What are the rules for removing non-numeric characters in the string, though?

What specifically do you mean by "standard" strings?...

Can't you do a simple

INSERT INTO DestinationTable(Col1, Col2, Col3...)

SELECT GrpBy1, GrpBy2, SUM(NumericField)

FROM SrcTable

GROUP BY GrpBy1, GrpBy2;

TinDog,

If you haven't done so already, check out PragmaticWorks.com Brian Knight knows SSAS inside and out. There are a bunch of free tutorials on their website. I think...

Read this article[/url]. Note the warning: "Downgrading to a lower edition cannot be done in place. This tip will describe the steps needed to downgrade."

If you can, install a copy...