Showing related tags and posts accross the entire site.
-
Ed Are you needing this because you want a formula against each row label? I normally handle this by taking the resulting pivot table and copying the data only to another sheet and then running some VBA over the row labels to fill the gaps. I have asked for some time for a setting to do this, but it...
-
Hi, I'm creating a pivot table and in column A I have row labels but when I have row labels in columns A & B column A only shows the label on each new occurance of a new label and I need to have the label (data) to appear for each line. Any suggestions Thanks Ed
-
I have a workbook with one sheet and a pivot table. The data is stored in a pivotcache. Is there a way to retrieve the underlying data of the pivot table without selecting a data field and using Selection.ShowDetail = True . Or can a display the records from the pivotcache from vba...? thnx
-
I am trying to create a "cascading" pivot table. Let me explain... If I have 2 columns of data with names of people who are in a direct reporting relationship. I want to show the data in columns as a hierarchy. So only those people who are not reporting to anyone would be in the far left column...
-
Problem definition: For my sales analyses I use for the last 3 years a separat tab for the database per year. Per year I have defined the same pivot table in order to seen sales per product group, customer, scustomer group etc. Wheneven I want to compare the data between diferent years I must do the...
-
The twitter experiment is now over. I used Tweetake to get my tweets into a CSV, which I then opened in Excel.
I tried to post every 1/2 hour. At the time of the post, I’d write what I did since the last post. Since I usually did more than one thing, I [...]
-
As many of you know, I don't do anything with technology 'in earnest', but love tinkering and it is great to have a 'project' with a functional 'end game'. Recently, I have been a little 'off' my usual Excel activity and developing (for fun) in the evening, on trains...
-
Hi Everyone - I have a stumper that several other boards did not have an answwer for, and I hope that someone can help. I have to run several pivots to fill a crystal xcelsius excel input model - two of them count partner company names and user IDs by region and country via the index function. What I...
-
Hi, I would like to create a Pivot Table where I have say four rows all in column format. They are Broker, Portfolio, Port ID, Rate(decimal). The data is Amounts in dollars. You have many variations across these four fields but for illustration and more particular to address my problem here is an example...
-
How do you communicate a pivot table to someone? I have a huge table of payroll transactions and I created a pivot table for my worker's compensation premium audit. Someone else who has Quickbooks could use this pivot table for their own purposes, but I don't know how to tell them how to [.....