disable the sub/grand total column in calculated memebers

Posted By:Posted Date:October 02, 2010Points:0Category :Sql Server

Is it possible to disable the sub/grand total column in calculated memebers programmatically. I don't want to display the sub/grand totals in pivot table? I know I can manually disable the sub/ grand totals in pivot table.

I have a cube where I added a calculated member to extract the last non null value of a measure. This is the script

Create Member CurrentCube.[Measures].[Trascinamento] as
iif(isempty([measures].[importo]),
([Data Rif].[Calendario].prevmember,[Measures].[Trascinamento]),
[measures].[importo]),
FORMAT_STRING = "Currency", VISIBLE = 1 ,
ASSOCIATED_MEASURE_GROUP = 'PUMA';

when viewing the aggregate data in a hierarchy, calculated totals and subtotals are accurate only if all the children of a member are zero at a certain date, and if either
has a value, the original total is not zero, and thus is also used in calculated member.

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA
for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),
- group by EntityID (101010,101011,101012....n),
- Qty: [Count(EntityID)]
- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA
for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),
- group by EntityID (101010,101011,101012....n),
- Qty: [Count(EntityID)]
- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like
the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with
the following structure:

- group by EntityType (bug ou userstory),
- group by EntityID (101010,101011,101012....n),
- Qty: [Count(EntityID)]
- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and
(sum(Fields!CycleTime.Value))<=55), 1, 0)

In many scenarios we need to display Running total as well as Grand total in GridView footer. In this post i will try to explain in an easy way that how we can display running total & Grand total in a GridView footer combindly. To explain this solution using an example here i use a sales order report. The report contains all sales order amount in a tabular way. I will use a GridView to display sales order amount and use GridView footer to display Running total & Grand total. Let we have a customer table with id and name column plus an orders table with OrderID,CustomerID,OrderDate & Amount. Now our goal is to show all customers order with amount as well as page wise running total & grand total. Note that running total is necessary when you enable paging in a GridView where as Grand total is always you can consider.

So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.

ÃÂ

Does anyone else experience this? If so is it a known problem and being worked on?

I am using BIDS 2005 version 8.0.50727.42
The fontName and Fontsize properties of calculated memebers are not working ? Any one got the same issue?
Thanks,
Alex

hi all, is there a workaround for overriding "grand totals" for calculated members? (I cannot use the workaround whereby I create the calculation in the DSV or view directly due to it being a pretty complex Descendant parent/child calculation).
thanks much for any thoughts,
Cos

Hello,
I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column.
Regards,
Sandeep

Implemantation:ÃÂ ÃÂ CalculateÃÂ expected resolveÃÂ date exclude "Saturday" and "Sunday"ÃÂ ÃÂ based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode:ÃÂ Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message.
=IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1),
ÃÂ
ÃÂ
IF(OR(Priority="HIGH",Severity="HIGH"),
IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2))
,
ÃÂ
IF(OR(Priority="MEDIUM",Severity="MEDIUM"),
IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3))
)
,
ÃÂ
IF(OR(Priority="LOW",Severity="LOW"),
IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

I'm trying to limit the calendar view to current week using the Sharepoint defined field Start Time. However, when I display the serial number behind the Start Time it looks like it is actually giving me the serial number for the Created Date field.
I believe it is because the appointment is reoccurring but I'm hoping there is a way around it. I created a new testdate field and manually entered the date and set those appointments as all day events however they are not reocurring appointments. The testdate
returns the correct serial number however the start time returns an incorrect serial number.
SerialNumber1=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))
SerialNumber2=DATE(YEAR([testdate]),MONTH([testdate]),DAY([testdate]))
Start Time SerialNumber1 Testdate SerialNumber2
8/31/2010 40420 8/31/2010 40421
8/31/2010* 40405
9/1/2010* 40405
9/2/2010* 40405
9/7/2010 40427 9/7/2010 40428
9/13/2010* 40405
9/14/2010 40434 9/14/2010 40435
9/14/2010* 40405
9/15/2010* 40405
*These are reoccurring appointments scheduled as all day events. The others were entered as one time appointments scheduled as all day events.

I have a survey list in Sharepoint 2007, which from what I understand means I can't add a calculated column.
In this survey list I have some number columns that need to be calculated for display. They are: (1) Number of Weeks, (2) Number of Hours per Week, and (3) Number of Hours for Credit.
In Sharepoint Designer, I've created a Data View Web Part which displays those columns and two additional "calculated columns." Scare quotes because the calculation is happening in the XSL of the web part, not an actual calculated column. These columns are
(4) Number of Hours (Column1*Column2) and (5) Eligible Hours (Column1*Column2-Column3).
I have the data view grouped by @Author (Created By) and a column total row for each group. I even figured out how to get column totals for all four columns though the nodeset is grouped by Author, which breaks out of the box. Great, beautiful.
The final step is sorting the entire view by the column total of Column5. In other words, I want my groups of @Authors listed in descending order by their Total Eligible Hours.
Is this possible?

All,
In Excel 2003, I have a product hierarchy, for simplistic sake lets say it goes A > B > C > model nbr. I have filtered on model nbr 1. I have the product hierarchy in my pivot table and unit cnt as the measure.
Starting at level A in the hierarchy I am showing a total unit of 12000, if I drill down to B it still shows 12000, if I drill down to C it shows 100 and if I drill down to model nbr it shows me model nbr 1 with a unit cnt of 100.
So my question is why are my parents not filtering the model nbr, it is taking the total for ALL records that have level A as their parent regardless of the model nbr?
This does NOT happen in Excel 2007 or when I browse my cube in SSAS.

Hi,
ÃÂ
I have a list withÃÂ a calculated column named 'FullName', the formula is: "FirstNameÃÂ & " "ÃÂ &ÃÂ ÃÂ LastName". I created a view group by 'FullName' column. The follow error appeared on the column:
ÃÂ
<!-- #RENDER FAILED -->
ÃÂ
Please help

## calculated member grand total e subtotal problem

hi,

I have a cube where I added a calculated member to extract the last non null value of a measure. This is the script

when viewing the aggregate data in a hierarchy, calculated totals and subtotals are accurate only if all the children of a member are zero at a certain date, and if either has a value, the original total is not zero, and thus is also used in calculated member.

Es

hierarchy | importo | trascinamento

100-----10| null | 10000

----20 | null &nb

## HELP: How to add Total to a row in a calculated column of a Matrix

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),

- group by EntityID (101010,101011,101012....n),

- Qty: [Count(EntityID)]

- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)

- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

## HELP: How to add Total to a row in a calculated column of a Matrix

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),

- group by EntityID (101010,101011,101012....n),

- Qty: [Count(EntityID)]

- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)

- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

## HELP: How to add Total to a row in a calculated column of a Matrix

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),

- group by EntityID (101010,101011,101012....n),

- Qty: [Count(EntityID)]

- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)

- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only

## Show grand total running total in GridView Footer

## How to get character count in 'Multiple Text 'column using Calculated Column?

Hi All,

I have a multiple text box in a list

I want

Appreciate all the help!

-saumil

## Trying to set Calendar Time Interval Using Calculated Column, but getting Error

ÃÂ

So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.

ÃÂ

Does anyone else experience this? If so is it a known problem and being worked on?

ÃÂ

Thanks!

Adam

## Font Expression in Calculated memebers?

## overriding "grand totals" for calculated members

## computed column specification - When is it calculated?

## In export, i want to disable column in excel sheet

## Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

## Use Sharepoint Calendar Start Time field in calculated column

## Sorting a DVWP by Column Total

## Excel 2003 pivot table - parent showing grand total than the sum of its children

## using [content type] in calculated column

## Problem when using calculated column as column group in a view