Re: remove (blank) rows from pivottable
Excel 2010 with free PowerPivot Add-In
Posts by Herbds7
-
-
Re: Pivot table display text in column rather than count
Admittedly a difficult task.
If you upload your complete, sanitized file,
I might write a custom code for you. -
Re: Pivot table display text in column rather than count
Excel 2010, PivotTable
With text inside PT.
With macros.
Generic data.
http://www.mediafire.com/view/zr5drzzoafnsfb0/04_04_11.xlsm -
Re: Substract data pivot from different filters
Quotedifference between current month and this month
Simple. Zero.
Or do you mean difference between the first date of the current month and today
vs the same period last month?
Or do you check only at the end of each month?
Do you account for different length of months and number of weekends
by using custom calendars? -
Re: Add new column in Pivottable using Count value
Excel 2010 with free PowerPivot Add-In
Divide by count of text.
http://www.mediafire.com/view/fbiahegtg5beaa9/03_24_14.xlsx
http://www.mediafire.com/view/6weqrh11nedn3f1/03_24_14.pdf -
Re: Compare to Total in Pivot Chart
All your particulars can easily be done with a few DAX formulas.
Look into this book:
"Microsoft Excel 2013, Building Data Models with PowerPivot"
by Alberto Ferrari and Marco Russo.
Months long learning curve. -
Re: Need help to look values of the respective sku in different column
Can't work with pictures.
Upload sanitized Excel file. -
Re: Compare to Total in Pivot Chart
Excel 2010 with free PowerPivot Add-In
Best done in PowerPivot.
Only second chart for revenue shown.
Rest left as an exercise for the gentle reader.
http://www.mediafire.com/view/39upfrc7x5iinn6/03_21_14a.xlsx
http://www.mediafire.com/view/muo4n4nlu160h60/03_21_14a.pdf -
Re: Pivot Table combining 2 columns for average & stddev
Excel 2010 with regular PivotTable.
Did not include your Cpk category,
which PowerPivot can easily handle,
but which would require a monster formula in regular PT.
http://www.mediafire.com/view/8d7fpt7yn9nd290/03_20_14.xlsx
http://www.mediafire.com/view/zzl9qxiy99ev84o/03_20_14.pdf -
Re: Pivot Table combining 2 columns for average & stddev
Excel 2010 with free PowerPivot Add-In
Data has to be de-normalized first.
No formulas, no code needed.
http://www.mediafire.com/view/hlf75wo3sx6lpc0/03_19_14.xlsx
http://www.mediafire.com/view/…7u0b/03_19_14.pdf</a><br> -
Re: COUNTIF Function and Creating Pivot Table
My program (macro) is based on counting events of discrete lengths,
occurring at random mm/dd/yy hh:mm:ss date/times
and lasting for random mm:ss of time.
To include any other features or formats would require re-writing the macro.
If you can't now read the current macro fluently, the task is well nigh out of your reach.
Good Luck. -
Re: COUNTIF Function and Creating Pivot Table
All you have to do is plug your undisclosed raw data into my Table2
and press the "Update" button.
The data you provided in your Excel file can not be used. -
Re: COUNTIF Function and Creating Pivot Table
Excel 2010, Table, PivotTable
Aggregating average data is not valid
since it leads to average of averages.
Use the raw data your array is based on to generate a PT.
An array is not a PT friendly format.
It should be in a tabular form.
Here is an example of a PT based on some fictitious tabular data:
http://www.mediafire.com/view/2nabu67jbn0jk7y/03_17_14b.xlsm -
Re: COUNTIF Function and Creating Pivot Table
Attach Excel file, not Word file.
Sanitize if needed. -
Re: matching text within 2 columns of 2 different worksheets to return row values in
Excel 2010, Tables
Cleaned up SS and did standard Index/Match
http://www.mediafire.com/view/lnwd7181nls1pj7/03_15_14.xlsx -
Re: Advanced filter with dynamic critieria range
Excel 2010 Table, PivotTable
The data you show is an aggregated array by week.
It is easier to work with the original, daily, tabular data,
which I created out of thin air in my example.
http://www.mediafire.com/view/yo2eatcodawl72t/03_15_14.xlsm
http://www.mediafire.com/view/yccynmc18gijosb/03_15_14.pdf -
Re: seating arrangement
Excel 2010 with free PowerPivot Add-In
Didn't see anything about floor plan, workstations, groups, days off and sharing.
But here is some graphical presentation of your start/end time.
Some fictitious data was added.
http://www.mediafire.com/view/3t70virzswdn5mf/03_12_14a.xlsm
http://www.mediafire.com/view/58vx35e1gra5rmm/03_12_14a.pdf -
Re: I would like to draw an arrow that follows the general path specified
Excel 2010, Tables
http://www.mediafire.com/view/ohiwxb468s45dm6/03_12_14.xlsm
http://www.mediafire.com/view/…1y83/03_12_14.pdf</a><br> -
Re: Creating a pivot on row with multiple columns of data
This is a Type2 PivotTable, not a regular Type1.
For a comparison see here:
http://www.mediafire.com/view/z3dixw4ginm/05_04_10.xlsx -
Re: Creating a pivot on row with multiple columns of data
Just a wild guess what you want.
http://www.mediafire.com/view/0wdi5tvxwkkuup9/03_07_14c.pdf