Dimensions Calculation in Pivot table

#1

When bringing the dimensions data in the cube the totals are calculated
automatically. Can I change that and calculate the difference instead of a
total?

Thanks
Tina

#2

Difference between what ?

If you need to make calculations between different time periods take a look
at the date
functions in AS - ytd and so forth....

"Tina" <Tina (AT) discussions (DOT) microsoft.com> wrote

Quote:

When bringing the dimensions data in the cube the totals are calculated
automatically. Can I change that and calculate the difference instead of
a
total?

Thanks
Tina

#3

I need to calculate the difference between the sales for each month of 2004
and corresponding month of 2005. The totals are calculated by the pivot
table automatically. I was wondering if there is any way to change the
calculation to display the differences.

Thanks
Tina

"Michael Vardinghus" wrote:

Quote:

Difference between what ?

If you need to make calculations between different time periods take a look
at the date
functions in AS - ytd and so forth....

"Tina" <Tina (AT) discussions (DOT) microsoft.com> wrote in message
news:862BD129-3632-43AD-A95E-AC4AD6BA319A (AT) microsoft (DOT) com...
When bringing the dimensions data in the cube the totals are calculated
automatically. Can I change that and calculate the difference instead of
a
total?

Thanks
Tina

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dimensions Calculation in Pivot table

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Dimensions Calculation in Pivot table - 06-01-2005 , 06:00 PM

Re: Dimensions Calculation in Pivot table - 06-02-2005 , 06:06 AM

Re: Dimensions Calculation in Pivot table - 06-03-2005 , 12:30 PM