Hi,
is there any way to add a custom column in a pivot table?
my requirement is something like this:
The dimension of cube has 4 columns. (Say A,B,C,D)
I need to have a Column Between C and D which is sum of Columns A,B and C.
does any one have information on this?
Thanks
Vinay

Below you say dimension of cube has 4 columns ... i interpret this as your
pivottable is on top
on an olap cube ? when you say 4 columns i interpret this as 4 measure
columns ? if it's 4 measure
columns you just need to put a calculated measure into the cube like this:

[measuses].[a]+[measures].[b]....

However - if this is wrong and what you're looking for is to get some kind
of subtotals into a dimension
with the 4 values specificed below you need to make this in you ETL
process - you need to group this
in an sql table like this:

Dim1 FatherDim
A F1
B F1
C F1
D F2

Then you can make fatherdim a level above dim1. I prefer snowflaking which
means splitting this in two tables:

Table 1
Dim1 FatherDim
A F1
B F1
C F1
D F2

Table 2
FatherDim
F1
F2

And in dimension editor i would join these two - the reason for doing so is
if i get some other info on the top level i
would just add columns here (member properties)

--Michael V.

"Vinay Joshi" <c-vjpshi (AT) state (DOT) pa.us> skrev i en meddelelse
news:O89NWb0lEHA.3872 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

thanks for the solution Michael....
I did this in some other way...
I created a calulated member and then added that to parent dimension...the
calculated member had the summation of other required columns of the
Dimensions....so it works..
thanks anyway..
Vinay

"Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote