Placing Sub Total Coulmn to the left of the coulumn in Matrix report

Hi,

If I am taking a Matrix and right clicking on the column header and click on the SubTotal then it always place that column on the right of it .If I want to place that column to the left of my original column then I can't do it.

Adding manual column and then puuting the Expresstion =Sum(Fields!MyCol.Value) is not halping as it will give me the same value that is there in the column instead of giving me the column

-Thanks,

Digs

Putting the same expression in the Row Group Header would give you some sort of a SubTotal to the left of your Data Column. However, this will obviously only give you only the sum and will not follow the same formatting & properties etc. as that in the Data Column.

HTH.

-Aayush

Place Unsorted row at end of detail

Hi There

I have a row returned from my stored procedure called 'Total', I would like it to appear at the bottom of the detail section rows.

I have placed the below expression on the sort on the table, trouble is now that 'Total' is not being sorted it appears at the top. Is there a way to get it to the bottom?

=iif(Fields!Item.Value <> "Total", true ,false)

Thanks in advance

Dave

several possible options

reverse the true and false part of your expression|||

Thanks for the reply,

-I cant reverse the true and false, as i need the rest of the rows sorted alphabetically

-need it sorted ascending

-Use an inetger, not sure whta you mean here?

Thanks

Dave

|||

Then put 2 things in your sort of the table:

firstly sort by: =iif(Fields!Item.Value <> "Total", 1 ,2)
then sort by: =Fields!Item.Value

So all your detail rows will get a 1 in the first sort expression and be sorted by name in the second expression and your total filed will get a 2 in the first expression and hence come after your detail rows.

|||

Legend,

Thanks fella that worked a treat!

PivotTable Total from Database

hi,
i'm trying to create a PivotTable in which I will be able to see totals coming from the database, not a calculated total field performed by the PivotTable. The data are structured with a hierarchical dimension for wich values are existing for each low level detail item and also for the high level detail item.
Is it possible to create a PivotTable based on a ROLAP(with SQL query) access that provide this kind of result (with total from the database).
For example, with the following table of data, I want to produced a PivotTable with 2 columns (E1Dim2 and E2Dim2 values) and 2 rows (E1Dim1 and E2Dim1 values). The PivotTable values are 100 for each dimension elements combinaison (the totals from database). Sure, I need to be able to drill one values on the row axis to see E11, E12 and E13 detail values.

id_meas1 val1_meas1 val2_meas1 des_dim1 des_dim11 des_dim2 1 10.23445 12.23445 E1Dim1 E11 E1Dim2 2 100 100 E1Dim1 E1Dim2 3 12.43356 13.34424 E1Dim1 E12 E1Dim2 4 14.34455 12.34234 E1Dim1 E13 E1Dim2 5 9.23423 8.53464 E1Dim1 E11 E2Dim2 6 100 100 E1Dim1 E2Dim2 7 10.23452 9.43234 E1Dim1 E12 E2Dim2 8 14.4532 12.3423 E1Dim1 E13 E2Dim2 9 8.23423 12.53464 E2Dim1 E11 E1Dim2 10 100 100 E2Dim1 E1Dim2 11 9.23452 14.43234 E2Dim1 E12 E1Dim2 12 12.4532 11.3423 E2Dim1 E13 E1Dim2 13 12.23423 13.53464 E2Dim1 E11 E2Dim2 14 100 100 E2Dim1 E2Dim2 15 10.23452 10.43234 E2Dim1 E12 E2Dim2 16 11.4532 12.3423 E2Dim1 E13 E2Dim2

Is it possible to get this behavior with ROLAP access?
Jeff

ROLAP is only storage mode you choose for your dimensions and partitions.

You should be able to change storage mode to ROLAP and continue to work as you were in MOLAP. The data you reciveing and the way you receive it should be the same.

Word of caution here:
If you are operating with large amounts of data you might get slower performance for your ROLAP dimensions and partitions.
Also during processing of MOLAP dimensions and partitions Analysis Server hides some of referential integrity problems you might have in relational database. Switching to ROLAP might surface these problems.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||my questionning is about how can I display TOTAL VALUES comming from database, not totals calculated by the pivottable?
I'm trying to create a pivottable in wich the detail and total values providing from database and not calculated by the pivottable. And I have a technological constraint, is to using MS-Access database, thus using SQLQuery and not MDX.

Is it possible to present detail values associate with the lower items level dimension and the total values associate with the higher items level dimension, without using total in the pivottable?

|||

Using Excel you can acomplish a lot. I am sure you should be able to find a solution for your problem.

This is probably a wrong forum for you question. Try and post it on the microsoft.public.excel newsgroup.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.