In one of the Rows in the Matrix, First Rows Represent Percentage of Subtotal of Second Rows's Value.In my Matrix , total i have 4 Rows, one of Row need to show a Percentage of Subtotal of Another Row.

How can i Reference that Row Values / Matrix subtotal Values Like that ?

Below is formate of my Matrix SSRS 2008 Report.

Jan Feb March

Mumbai 48% 51% 41% <---Represent of Second Row - Bangalore Percentage of Subtotal

Bangalore 135 192 197

Delhi 149 185 278

Total 284 377 485

How can i reference, One Cell Value from other Cell's and Subtotal for the Percentage Calculation in SSRS 2008 Matrix ?

I would like to calculate percentage for banglore. Such as 135/284.. do you kno what i mean.

How do I go about defining the "NewMeasure" calculated member in my AS2008 Enterprise cube? The NewMeasure should essentially be the total $ amount for all SKUs in the current PivotTable.

What I'm really after, in this particular example, would be the percentage of a given SKU's $ amount relative to the total $ amount for all SKUs in the current pivot. I figured if I can get the "NewMeasure" logic figured out, the above would
be easy.

This page presents a variety of calculations for latitude/longitude points, with the formulÃÂ¦ and code fragments for implementing them.

All these formulÃÂ¦ are for calculations on the basis of a spherical earth (ignoring ellipsoidal effects) - which is accurate enough* for most purposes. [In fact, the earth is very slightly ellipsoidal; using a spherical model gives errors typically up to 0.3% - see notes for further details].

We offer many Global Database Products that you can use with the below formulas to calculate distances and many other uses. Not sure how to use distance calculations or global databases within your company? See our Global Database Examples for more information on how to use our data within your industry. Be sure to Download a Free Sample of one of our many Global Database Products.

I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.

I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.

Hi, Following code will help the developer to calculate exact client height in all browsers.script language="javascript" type="text/javascript">var winW = 630, winH = 460;if (parseInt(navigator.appVersion)>3) {if (navigator.appName

how do I go about generating formulas for something like this.

I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High =
1 day, exclude weekends.

Is there anyway where we can use KPI list to attach to a SharePoint list and indicates which item was clicked the most ? Or any other way to find out the best 5 links based on how many times they were accessed by a user?

Hi ALL, I have scheduled hours of each employee for each week and no of days scheduled in a week.i want to get reports for weekly wise no of employees scheduled less 24 hrs per week,b/w 24 and 48 hrs and greater than 48 hrs
Scheduled Hrs 8/1/2010 8/8/2010 15/8/2010 22/8/2010
Less than 24 hrs 5% 5% 5% 4%
b/w 24 and 48 hrs 4% 6% &

Hi all,
I want to calcultae how many employees are scheduled less 24 hrs for each week,b/w 24 and 48 and greater than 48
In excel file i have weekly wise total hours scheduled for each employee and total no of days scheduled in week(example 6 days and 1 off)which i will upload it to database,based on this i want to display reports in bound controls Result should be like this
Scheduled Hrs 8/1/2010 8/8/2010 8/15/2010 8/22/2010
Less than 24 hrs 5% 5% 5% 5%
Between 24 and 48 hrs 5%

Hi, I'm having performance issue with calculated member (Running total) which is created on one dimension in the cube. Cube is having three dimension Product Details(Product Model, Product Type) , Time(Year & Month) & Qty type(In Qty
& Out qty). See below for details
Dimtime
Year (Values 2000 to 2020) Month
DimProd
Product No Product Type Product Group
DimQty Type
In Qty Out Qty
Fact Table
Product No Year Month Qty Type of Qty( In Qty or Out Qty )
My MDX query for calculated member is
CREATE MEMBER [Qty Type].[Qty Type].[All].[Total] as
SUM(NULL:[TimeDim].[Hierarchy].CurrentMember , ([Qty Type].[Qty Type].[In Qty], Measures.[Qty]) - ([Qty Type].[Qty Type].[Out Qty], Measures.[Qty])
The formula is --> Total = Previous Period Total Qty + Inqty - Out Qty
This works perfectly when i browse at higher level (Qty Type on Rows & Time On Columns), but when i browse the cube adding dimension Product Details( Product group or Product Type) to Drill-through the
In Qty & Out Qty, the query is running and after one hour also it's not finished. Can anyone help me to solve this or propose new structure to resolve this issue.

Hi,
Im using "#PERCENT{P2}" this one to calculate percentage in pie chart. It should take 2 decimal only rite?
But it is taking 3 decimal values.
Example:
20.90678
After applying the formula "#PERCENT{P2}" it is showing as 20.91
i want to show as 20.90 only pls help me
Thanks in advance,
Abdul2010

Hey guys,
I got a problem and I hope someone could help me with it.
I have the following scenario which I need to solve. The Schema looks something lilke that...
DIM3
DIM3_Key
Dim3_Att
FactlessFact_DIM3_DIM4
DIM3_Key
DIM4_Key
WeightingFactor
DIM4
DIM4_Key
Dim4_Att
FACT
DIM1_Key
DIM3_Key
Sales_Fact
DIM1
DIM1_Key
Dim1_Att
FactlessFact_DIM1_DIM2
DIM1_Key
DIM2_Key
WeightingFactor
DIM2
DIM2_Key
Dim2_Att
As you can see my Facttable is connected to two dimension which are actually many to many. Also there is a 'WeightingFactor' in every FactlessFact table (BRIDGE), so that i am able to correct (as defined by the factors) values when ever I query DIM2_Att
or DIM4_ATT.
So the Problem I have is that I every Fact shoud be MULTIPLIED with the WEIGHTING FACTOR. Well in MSAS 2008 I can do that with an Measured expression but since a measure needs to be unique I cannot just use 'WeightingFactor'.
So When I renamed it to WeightingFactor34 and WeightingFactor12. But this only gives me the correct values for the defined Path. In case I use WeightingFactor12 i only get the correct values for DIM2_ATT but not for DIM4_ATT.
I guess I need to solve this with a calculated Measure???? Am I right? I am new to MSAS and also new with MDX and all this stuff...
How can use a calculated meas

Hi all,
I am trying to calculate rank of the objects based on sales.
It should only change for date dimension.
For all other dimension attributes, it should remain the same.
Please help me out.
Thanks,
Sam

Hi All,i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday).
I want result in percentage.result like thisConsistency Days of assignment Across 4 weeks 3 weeks 2weeks 0 2% 0% &

Hi all ,
i have a pie chart and show percentage as label ,i set label data as #PERCENT{P0}
but when report runs it has 3 value: 58%,11%,32%
you can see the 3 value add up to 101%
is something else i need to set on label ?
any help for this ?

## Use one cell`s value onto aother Cell to calculate percentage in SSRS 2008

Pls help me with my below issue.

Hi,

I developed SSRS 2008 Matrix Report.

In one of the Rows in the Matrix, First Rows Represent Percentage of Subtotal of Second Rows's Value.In my Matrix , total i have 4 Rows, one of Row need to show a Percentage of Subtotal of Another Row.

How can i Reference that Row Values / Matrix subtotal Values Like that ?

Below is formate of my Matrix SSRS 2008 Report.

Jan Feb March

Mumbai 48% 51% 41% <---Represent of Second Row - Bangalore Percentage of Subtotal

Bangalore 135 192 197

Delhi 149 185 278

Total 284 377 485

How can i reference, One Cell Value from other Cell's and Subtotal for the Percentage Calculation in SSRS 2008 Matrix ?

I would like to calculate percentage for banglore. Such as 135/284.. do you kno what i mean.

Please help me!!

Let me know if need information.

Thanks.

Shalin