Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
Shivakumaran

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

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.

### Show grand total running total in GridView Footer

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.

### Tablix - Grand Total not match up

I'm having a problem in my grand totals when using tablix. You can notice that grand totals are not totalling up. Name Code Total  Items No of Users Total  Due % Due Total Completed % Completed Company Units # of Units Health System 00 447,041 5,163 35,422 8% 411,597 92% Test A CEU 2218.75 Test B CEU 4305.5 Test C Hours 22121 Test D ct Hours 15.8 Test E CEU 18.75 Hospitals 01 47,952 511 2,099 4% 45,853 96% Test A CEU 34.25 Test B CEU 136 Test C Hours 1823.25 Non-Health 9999 9,643 658 2,064 21% 7,579 79% Test C CEU 11.5 Test D CEU 17.75 Test E Hours 478 Trainings Test 34 9 22 65% 12 35%     0 Grand Total:    2,408,024 29,331 189,621 8% 2,218,293 92%

### TopCount dynamic named set + "Others" and "Grand Total"

After going through all available posts, unfortunately I could not find a solution for my problem. I have to create a dynamic named set of with TopCount in a cube that will be accessed with excel 2007. This how the outcome should look like:

Brand_A        \$50.00

Brand_Z        \$40.00

Brand_B        \$10.00

Others           \$200.00

Grand Total   \$300.00

This is the MDX I used which gives me the top 3 but not the "Others" and the "Grand Total." Just to keep it simple I used top 3 Brands.

```CREATE DYNAMIC SET CURRENTCUBE.[Top 3 Brands]
AS
TopCount
(
[NDD].[Brand].[Brand].Members,
3,
[Measures].[Sales]
)

, DISPLAY_FOLDER = 'Sets';```

Now I am stuck here. After reviewing many posts it seems that Excel 2007 has some issues with handling sets. I found two possible solutions from Raymond-Lee which I think may work.

Solution 1 - Use a named query in dsv

Solution 2 - create a dummy "Others"

Here is the post: http://social.msdn.microsoft.com/Forums/en-US/sqlanalys

### disable the sub/grand total column in calculated memebers

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.

Alex,

### 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

```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.

Es

hierarchy |          importo       | trascinamento

100-----10|     null                  |         10000
----20 |     null            &nb

### Can I display "Grand Total" at the left of a Pivot table?

I have an end user request to display “Grand Total” at the left of a Pivot Table. The client uses Excel 2007 and SSAS 2005

For instance, take a look the grand total at the left of the table

Grand Total       Laptop      Desktop                  Electronics

CA                          1000<

### Wrong Grand Total value

Hi Guys,

I have the following MDX Script gives me a wrong Grand Total Values.

CREATE

MEMBER CURRENTCUBE.[Measures].HC

AS ([Measures].[DC] , [RowType].[Row Type Key].&[6]),

FORMAT_STRING

= "#,##0;-#,##0",

### Get the "Grand total" with mdx ?

Hi,

how can i use the grand total of a measure to calculate with?

I tried something like [Measures].[MeasureName].xxx but i didnt found the correct one.

thank you.

### Grand Total problem in SSRS export to PDF

Hi,

I have one report in which i have to show list of patients, department wise.. so i added one group for Department and patient belonging to respected department fall under that group.. but the requirement is each department (group) should start from new page.. till now everything works fine.. now the point is at the end of report i have to print total no. of patients (Grand total) included in all departments.. but this Grand Total is appearing one new page even if previous page completes half of the page, as i have activted "New Page After" for group property.. how to overcome this problem ?

With Regards.

Sudha Thiru

### Display grand total without subtotal

Hi

Below is my testcase. I want to display grand total without any sub total.

```create table report (name varchar(6),type1 varchar(6),amt int)

insert into report values( 'ABC','BILL',200)

insert into report values( 'DEF','BILL',200)

insert into report values( 'ABC','Query',100)

insert into report values( 'DEF','Query',100)

insert into report values( ```

### Grand total problem using sum(descedant) function

Hi there:

I use the sum descendant function to sum the employees that has a sale using the following MDX

Employee with sale =

Sum(
Descendants([Employees].[Employees].CurrentMember,,LEAVES)
,[Measures].[Employee wSales Count1]
)

The result is like this if I have all job category selected.

Employee Group

Employee Count

Employee with sale

### IIF works on calcd member but grand total is wrong

Hi.  I'm working on a conditional piece of mdx that started looking like what you see way below.  The idea is to modify this measure's behavior based on which dimension was chosen without nesting scope statements.  The detail and date hierarchy level numbers look good on Date A but the grand total is 0 when I dice on Date A.  I suspect what was posted at

explains why this happens but the solution given there applies to a different class of problem (I think).

Can someone help to explain how grand totals etc can be aggregated properly for calc'd measures? I tried multiplying [Whatever Orig] by 1 and even put the calc'd member in a different measure group to no avail.  I also used a raw assignment prior to the calculate that kind of looked like [measures].[Whatever Orig] = IIF(ROOT([Date A]),0,...) ; but that didnt work either.  Eventually there will be more scope statements.

CALCULATE;

### UDP Delivers: Take Total Control Of Your Networking With .NET And UDP

UDP, the lesser-known sibling of TCP, is used for DNS resolution, SNMP network status, Kerberos security, digital media streaming, VoIP, and lots more. Learn how to put UDP to work for you.

Yaniv Pessach

MSDN Magazine February 2006

### Total newbie question: Calling jQuery in an UpdatePanel?

Hi,

Please forgive this ignorant question - I've used ASP.NET AJAX a good deal but I'm new to jQuery.  Specifically, is it possible to call or create jQuery events on the fly via an UpdatePanel?  For example, calling a jQuery modal or animating a Label (or <div> contained Literal), etc.

If anyone has any advice or could point me to some easy tutorials on mixing ASP.NET AJAX and jQuery, I'd greatly appreciate it.

Thanks!

-P

### Calculating GridView total using JavaScript/JQuery

Hello everyone.

One month ago I've had very nice conversation with a asp.net forum member asking about issue regarding calculation of GridView textboxes total using JavaScript. The main thing was to allow user to manually write values in the text boxes (placed inside GridView column) and if the value has changed automatically to perform calculation on client side.

At the end of the conversation, we came up to two solutions. The first solution was using plain JavaScript, but since I thought it was not so robust, and in order to make it more robust we would need to write few more functions. Therefore, I have simply proposed another solution using JQuery which came up much better, more robust with less code.

In this blog post I will show both of the solutions and will provide step by step explanation on how we did that.

Note: I'm using VWD.

### Get cumulative total value on x-axis.

I'm currently displaying: January \$200 February \$100 March \$400 I want to display:( i've set the custom to MMM on the axis-properties, but still the months are not getting into below required format)  Jan \$200 Feb \$100 Mar \$400 Total \$700 on the x-axis.  And i want the y-axis to be divided in the intervals of 200, but though i've set the interval as 200, it is displaying in divisions of 2000.
 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All