Newbie OLAP pivottable filter and sort on values
I have the simpliest of cube pivottables: Year as report filter, Products as
Row labels and Amount as value.
Is there a way to filter (a cube pivottable) rows on values ie "amount >
1000" or "amount <> 0" ? I only find (when rightclicking Products row label)
"Filter top 10".
I use Excel2007 and AnalysisServices2005 sp3 cubes.
...Hiding rows containing zeroes or blanks in pivot tables?
How do I hide rows containing zeroes or blanks in pivot tables?
You can use programming to hide the rows with a zero total. For example:
'hide worksheet rows that contain all zeros
Dim rng As Range
For Each rng In ActiveSheet _
If Application.Sum(rng) = 0 Then
rng.EntireRow.Hidden = True
'unhide any previously hidden rows
rng.EntireRow.Hidden = False
'unhide all...Discontinuos lines in the same series
I have 2 discontinuos ranges for a series.
X: AB203:205 AB209:212
Y: AC203:205 Ac209:212
the problem is that this results in a single line while I want it to b
2 separate lines with a gap when the ranges change. Is this possible?
don't want to use 2 series to achieve the same because I keep changin
the range of the series using a macro. This is the only case where
have a discontinuous range. Other cases all have continuous ranges.
routeram's Profile: http://www.excelforum.com/m...Area charts and blank cells
I'm trying to plot costs vs. time (month) on an area chart. I want to split
up the costs by time, so I've created a bunch of different data series which
look something like:
Jan Feb Mar Apr May Jun
$2 $6 $1
$3 $8 $4
This is basically just breaking up the original data series... ie
Jan Feb Mar Apr May Jun
$2 $6 $1 $3 $8 $4
I was hoping this would produce a nice, continuous area chart sectioned off
by colour. The problem is that it interprets the blank spaces as zero and so
I get these weird e...Error: The node to be inserted is from a different document context
I'm getting an error that I'm very confused about. I'm trying to
generate an XML file completely from scratch in code. Here is the code
fragment that is causing me headaches:
Dim mBOEDOC as xml.xmldocument
dim inode as xml.xmlnode
dim iNode2 as xml.Xmlnode
inode2=mboedoc.createnode(xml.XmlNodeType.Document, "BOETask", "")
iNode = mBOEDoc.createnode(xml.xmlnodetype.Element, "Program","")
The error is showing up on the appendchild procedure. I'm gene...RMS and SAGE Line 50
Does anybody use sage in conjunction with RMS, and if so what software do
you use to link the 2 and how does it work? i.e. how do i reconcile an
invoice with a purchase order etc.
"Philip Gass" wrote:
> Does anybody use sage in conjunction with RMS, and if so what software do
> you use to link the 2 and how does it work? i.e. how do i reconcile an
> invoice with a purchase order etc.
We can probably help. As Sage Line 50 Developers we understand the import
and export of Line 50 transactions via ODBC and Sage Data Objects.
Please e-mail me wi...Sort creating total errors
I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical
data in most of the columns corresponding to people. Like this:
John 9 6
Debbie 9 5
James 8 5
Total 26 16
If I highlight all columns and do a sort by the person's name, the total
number at the bottom changes even if the data has not changed. Do you know
why this is happening?
Thanks in advance for any help!
What are the formulas you used in those total cells?
excel idiot wrote:
> I have a spreadsheet with about 20 columns and 8,000 rows. I have numerica...Why does blank pages print inside a booklet I created in Publisher
I created a booklet in publisher and when I print the booklet everything
prints out okay except for the inside of the book, a blank page prints. Why,
and what can I do to fix it so the following pages can print consistently.
How many pages do you have in your booklet? It needs to be a multiple of 4.
Microsoft MVP - Publisher
How to ask a question
"Publisher General Question" <Publisher General
Question@discussions.microsoft.com> wrote in message
>I c...SOP line item status
Is there a field in the "Sales transaction amounts work" table that is
updated when we post a receiving for a PO line item which is linked to SOP
sales line item?
Also, once an SOP order is transferred to an invoice is there a field on the
"Sales transaction amounts work" or "Sales transaction amounts history" that
is updated for the sales order line item?
The Quantity Received is updated. SOP60100, by the way, is the link between
PO and SOP if you want purchase order numbers.
I could not find a field in the line item tab...coloured roes static while sorting data
I want to set up a list that has alternating coloured rows to make it more
legible but I want the coloured rows to remain static while the data is
sorted in various ways. Is it possible to do this? I have used the list
template in excel but the gray row colour is less than ideal. I want to use a
pale yellow and a pale green alternating.
see if this site helps you out.
> I want to set up a list that has alternating coloured rows to make it more
> legible but I want the coloured...Return All Record if Check Box is Blank
How would I return a subset of records if a form check box is checked but
return all records if the check box is blank.
The formcheck box is: [Forms]![frm_switchboard]![chk_rndm]
The field [RandomMarker] can have the values of "Y" or Null only.
The following SQL pulls the correct data when the check box is checked, but
I recive an "OpenForm action was canceled" when the box is blank. How would I
modify the query to pull all results ([RandomMarker]="Y" or Null) when the
box is not checked?
SELECT tbl_tt_trans.TransNo, tbl_tt_trans.Fac, tbl_tt_tran...Same series, different coloured line?
If I have a continuos data series populating a chart, is there any way of
having some of the values plot in a different style line?
i.e I have 24 values, half of which are extrapolated which I format in red.
They are all the same series but I want the red formatted, extrapolated
values to chart as a dotted line.
Is there any quick way of doing this without breaking it into more than one
Any help greatly appreciated.
...Sorting views....what's up??????
I've seen a couple of posts on this and just cannot believe what I'm
We've created several custom account views (ie Active Accounts,
Inactive Accounts, My Accounts, etc). We've added 10+ so far, and were
planning on adding more to the drop down list.
All of a sudden out of the blue this morning the views are in a
completely random order. All along they've been sorted alphabetically.
Now today, they're completed jumbled in the drop down and unusable.
I'm reading that there is no way to resort - is this true?? And why
would it all of a sudden b...Global Signature Line
How can I assign a global signature line to all my outlook users (possilby
from within Exchange 2007)? Is there a way to control this and assign to all
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"dswindell" <email@example.com> wrote in message
All of a sudden, in a particular file, I find that Excel won't sort
properly. I have about 15 columns, with headings, and normally if I want
to sort I click in the relevant column and I get a dialog which ask me
if I want to sort by ..... and it uses the column heading name, and the
'my list has a header row' defaults to 'yes'. No problem.
But one file doesn't do all this. The 'my list has a header row'
defaults to 'no' and the 'sort by .....' uses the column
letter. Now these issues would not be a problem if I could simply click
...Deleting the (blank) cell out of a Pivot Table
I'm trying to delete the cell that reads "(blank)" on a Pivot Table, I have
tried every possible setting(except for your advice)and I cant achieve this
setting. I'm trying to print the pivot table as a table and I don't want to
see the "(blank)" cell written.
Thank you for your help!
You could hide the (blank) entries with conditional formatting:
1. Select the cells in the pivot table
2. Choose Format>Conditional Formatting
3. Leave the first dropdown as Cell Value Is
4. From the centre dropdown, choose Equal to
5. In the text box, type (Blank)
6...Tracking Changes Made By Sorting
I am working with a large list and would like to be able
to see what changes were made when I sort the data
(alphabetical sort). Can this be done without having to
go through and check manually?
...Why are all my Word documents blank?
Lately my Word docs are coming up blank, whether I open from a folder, from
Word, view in print preview, etc. I can open them in WordPad and the text is
displayed. But not in Word. I'm in Office 2003 on an HP Pavilion laptop. A
restart solves the problem, but it keeps happening.
...No blank in unbound text box
I have a form with an unbound text box, and then a button. You select
from the dropdown (which gets its list from a query) and then push the
button. What I don't want is when the form opens, and the textbox is
blank, for the button to be pushable. So the user has to select
something from the list first.
On Wed, 6 Jan 2010 17:57:06 -0800 (PST), Lostguy <firstname.lastname@example.org> wrote:
>I have a form with an unbound text box, and then a button. You select
>from the dropdown (which gets its list from a query) and th...Print Range Lines
Is there any way to turn off the dotted lines that show the print range area
I don't know why someone would want them unavailable, but a co-worker of
mine insists "they don't turn on half of the time anyway, so why use/show
them at all?"
We use Excel 2003.
Tools>options>view and under window options deselect page breaks
"Me" <Me@discussions.microsoft.com> wrote in message
> Is there any way to turn off the dotted lines that show ...Excel Scatter Plot with connected by smooth lines
It is not honoring my numbers for the X-Axis, they go from -1300 to 3200, on
the graph it's going from -8900 to -8200, but when i go to the source data my
numbers for the X-Axis are selected how do i change this? Its urgent!!!
Double click on the x axis and on the Scale tab manually select minimum
and maximum for the scale.
If you inserted the graph, instead of changing data on an existing
graph, then there is something else going on, since by default Excel
will encompass the entire range.
You might also select the chart and on the menu select Chat|Chart type
to ensure that you ha...Paste Special Skip Blanks not skipping blanks, but overwriting...
Using Excel 2003, I'm having problems getting the "skip blanks" feature to
work. It works on one computer using 2003, but not on another. I updated,
but still have the problem.
...Changing CListCtrl Report View Line Height
Is it possible to change the height of a line in the CListCtrl report view?
If so, how? I don't need to make each line a different height (although that
would be nice); just changing the global height would be sufficient.
I don't know how to do it directly, but I know of a "hack" that should work.
The ClistCtrl adjusts to height of a row so as to accommodate an image at
the head of the row. So, call SetImageList and pass in a CImageList that
contains a transparent image of the desired height, and maybe only one pixel
wide so that there's not an unnatural spa...How do I lock a row in place so that when I sort the worksheet, t.
How do I lock a row in place so that when I sort the worksheet, the row stays
at its location, and the other rows sort around it?
I believe you can use Data/Filter. Ideally there is already some column in
the worksheet that will show all of the records but that row (maybe a
helper column would be necessary). Then sort the data and set the filter to
show all records.
"primenumber" <email@example.com> wrote in message
> How do I lock a row in place so that when I sort the worksheet, the r...blank cells being counted ??
Wondering if someone could help with this problem
After doing a vlookup and then cleaning up with pastespecial/values
I am finding that the visually empty cells are still being counted in my
I have tried this subroutine to clearcontents on the empty cells, which
works if I do it manually.
For i = 3 To 588
If Cells(i, 14) = "" Then
Can anyone tell me 1. why my clearcontents subrouting is not clearing
and 2. is there another way to clear out this invisible data i...